Grand Totals on Vertical Block Alignments?

Jon De Leon

Hi Everyone,
I have this Data View with a Vertical Block Alignment, with Location Group on the columns and Categories on the Rows, with the Data for each  Category

Thank you!

Is there a way to get a Total of the Categories for each Data Cube?  Ideally, there would be a "Grand Total" After "Activity/Toy" with the same six lines. 

------------------------------
Jon De Leon
Manager, Financial Analytics

United States
------------------------------

Navan Mehra

Not sure if you still have this requirement or you found an answer. Anyhow, have you tried using the dt, rt and gt functions in the algrithms?

dt stand for downtotal and can be used as dt(columnname)
gt stands for grand total and can be used as gt(columnname)
rt stands for row totals and can be used as rt(columnname)

------------------------------
Navan Mehra
Senior Consultant
Board Community
Australia
------------------------------
-------------------------------------------