Is there a way to get a grand grand total

Jack Footer

Hi guys,

 

I know there is the algorithm gt() in order to get the grand total of the subsection in a dataview but is there an option to get the overall grand total of the whole table? 

 

I have tried using nexel and can only get the very bottom down total annoyingly... (so close)! by using Point.Total. 

 

The issue arises as I want a percentage mix based on the grand grand total.

 

TIA 

 

Jack

Björn Reuber

Hi,

 

right now there is now direct way to get the grand grand total. But depending on your DataModel/DataView you can use Totalby or you do the pre-aggregation in a certain cube on a different level.

 

Regards

Björn