Total in Pivot Table

[#1]

Hi,

Any idea how to create the pivot table as below?

If I used the partial sum in pivot table, it's give

Another alternative way is create the Dimension2 as expressions, then drag down to left. These then need create all the tables for budget, LY and etc and hiding behind.

Disadvantage is user couldn't export whole table to excel.

[jonathandienst]

Hi

You could add 'Total' to Dimension 1:

Concatenate

LOAD 'Total' As Dimension1,

     ...

Autogenerate 1;

and then your expressions would need to say something like:

     If(Dimension1 = 'Total', Sum(Aggr(< your original expression >, Dimension1, Dimension2)), < your original expression >)

And finally, use custom cell formatting to bold the lines with Total. Or click the + next to the expression, and enter the text style expression:

     If(Dimension1 = 'Total', '<B>')

HTH

Jonathan

[danieloberbilli]

You could script the 'Total' as an additional value to the Dimension1 field by calculating the sums in a seperate logical table and then join it/ or use crosstable load to create the final table....but then there is no dynamic user selection on the dashboard possible...the Totals will be rather static.

[#4]

Please find the attached document

[#5]

Thanks. Need to think a way to create that column in backend. Alright, thanks.