Pivot Totals

[#1]

Hi

A simple question...

I have a Pivot Table with Year as primary Pivot and then Budget Topics. How do I get a full sum of all budget topics for the year ?

Meir

[veidlburkhard]

Hi Meir,

add a last expression to your expression list like column(1) + column(2) +...+ column(n) and name it 'Total Budget'.

Then for every year you will get the sum of all budget topics as a last column at the end of your pivot table.

Hope this helps

Burkhard

[maxgro]

try this:

in tab Presentation of Pivot Table chart  there is a check box for Partial Sum

[#4]

HI

Thanks for the suggestions. The best solution was to import using the pivot wizard.

Regards

Meir

[#5]

Hi

Thanks I was thinking that would be the solution but there are about 25 columns so its a bit tedious.

I decided to import the table using the pivot that way I have the drill down and the partial sum solution.

Regards

Meir