EV_AFTER : Adding grand total BPC 7.5

[Former Member]

Hi All,

Report details;

Only 1 Dimension in row Key range

Hardcoded many DIM values on Column key range

Need to sort the report based on a column( Used EVPRO to get the values for this column)

Used EV_Before to add a heading to based on the sorted values

Used EV_After to add subtotal based on sorted values

Now I need to add a grand total and also insert a row in between these totals.

e.g:

I have sorted column k which has values A,B,C and D. So my report is clubbing all A values and displaying it under the heading A and a subtotal after clubbing all values.

Now I need to add a row whic will show a sum of "Total A" + "total B" + Total C = X and then a grand total which has a sum of X+Total D. something like the attached image. Please help.

[former_member186338 · Accepted solution]

Hi Kimi,

Your requirement to add some partial subtotal can't be implemented with some universal logic - it means that you have to create the whole report as static with standard Excel formulas for totals...

B.R. Vadim

[Former Member · Accepted solution]

Vadim,

Thanks for replying.

The values A,B,C,D keep changing, meaning if there are 3 rows with values A, next week it could be 4 rows or 2 rows. For this reason I could not create a static report. Also are very specific about the frmatting that they want hence I cannot reference the report using excel.

Thanks,

Kimi

[former_member186338 · Accepted solution]

You can create report with 2 EVDRE one after one:

First for A,B,C

Second for D

Expansion will not overwrite the second evdre...

Vadim

[blu_taz18 · Accepted solution]

Hi Kimi,

Based on your report it is impossible that you only use 1 dimension in row key range.

It should be two or more to create different values.

My advise is to create another EV_AFTER using the other row dimension

for example

Hope it helps.

Thanks

Regards,

Mitch

[Former Member · Accepted solution]

Thanks Vadim. This logic helped. I was able to create the report with 2 EVDRE's

[Former Member · Accepted solution]

Thanks for your detailed reply Mitch!!!

[blu_taz18 · Accepted solution]

Hi Kimi,

You are welcome

Thanks

Regards,

Mitch