Pivot Table total outside dimension

[#1]

Hi All,

I'm looking for a solution to a particular problem that I have. Please see table below.

This is a pivot table with two dimensions, COLOUR and PRODUCTGROUP. I have pivoted the PRODUCTGROUP dimension as seen above.

Effectively I would like a bunch of TOTAL columns that are exactly the same as the expressions above.

In presentation this would look like below.

Thanks for your help.

[sushil353 · Accepted solution]

Hi,

In the presentation Tab select the Product group dimension and click on show partial sum.

HTH

sushil

[#3]

You hero! perfect!