Total Pivot table

[emteam162]

Hi all,

I want to have the total column in my pivot table as :

                 A      B       C        total

total          11     22     33          66

AA             10     20     30          60

BB               1       2      3           6

Many thanks,

Best Regards,

Emteam

[Gysbert_Wassenaar]

Enable Partial sums for the two dimensions of your pivot table on the Presentation tab of the properties window.

[emteam162]

Hi,

I am doing that but doesn't work.

Many thanks

Emteam

[emteam162]

Hi Gysbert Wassenaar

I want in my presentation to have

                   A      B       C        total

total          11     22     33          66

AA             10     20     30          60

BB               1       2      3           6

Not

             total   A      B       C       

total     66     11     22     33        

AA         60    10     20     30         

BB           6    1       2      3          

Many thanks

Emteam

[#5 · Accepted solution]

Hi

in this case, manage Totals by yourself and store it as fields.

You will be then able to manage the position you want them to appear.

best regards

chris

[emteam162]

Hi christianj,

Many thanks for your answer.

Best Regards,

Emteam