Skip to Content
Former Member
Jan 07, 2012 at 02:11 AM



Hi Gurus,

I have a situation that i need to expand by using filtering and also use multiple data ranges, so using Pipe(|) when i filter in the expansion, I also use EVafter of Sort on a column (which has EVPRO) to sort on a field that belong to a different dimension,

My objective is just to display the SUM (SUBTOTAL) which was created by EVAfter, and also like to have the Grand Total of several Subtotals.

Would you please help me with

1) How to just display the SUM (SUBTOTAL) which was created by EVAfter (hiding all the detail rows)

2) How to create a Grand total of all the subtotals.

Thanks for your help.