Skip to Content
0
Former Member
Mar 01, 2010 at 09:57 PM

collecting sum of subtotals in a section webi 3.1

26 Views

All,

I have a section in a report. Consider the dimensions as

 [Country], [State] and [Measure] as Sales  

When i create a section on Country, i get subtotals of Sales for every country.

However i am stumped when i try to get a grand total. I have tried a

 RunningSum([Sales]), [Sales] In Report ( extended operator) 

etc - but i am unable to get the grandtotal in this report.

Am i missing something simple here? Any advice would be greatly appreciated.

Regards

Edited by: ramaks on Mar 1, 2010 10:58 PM