on 07-19-2011 12:41 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.