cancel
Showing results for 
Search instead for 
Did you mean: 

Excel BPC - Totals & Subtotals

Former Member
0 Kudos

Hi

I have an EvDRE ( Excel BPC 7.5 ) and would like to add a Total to the rows, I can't use the parent as I have a mix of Product Lines.

I've tried EvSUM in the after range of the Rows, and EvSUB in the Sorting range, but neither appears to work.

Is there an easy way to add a Total to the end of the rows ?

Thanks in advance for your help.

Kind Regards

Gav

Accepted Solutions (1)

Accepted Solutions (1)

PatrickFavre
Advisor
Advisor
0 Kudos

Hi,

The use of EVSUM keyword is correct, but you should reference it in the right section.

In the AfterRange of your rows expansion, you should use the EVRNG function and refer to (for example) A1:B1 range.

And in A1 you write "Total" and in B1 you write "EVSUM".

This should work in any case.

Hope this will help.

Kind Regards,

Patrick

Former Member
0 Kudos

Thank you Patrick, problem solved, I was typing EvSUM in the Afterrange box itself.

Answers (0)