Is there a way to get a grand grand total

Jack Footer
Jack Footer Active Partner
Fourth Anniversary 25 Up Votes First Comment
in Platform

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

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    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

Categories