Totals Amounts in Pivot Table

[#1]

Dears,

Good day.

I have a pivot table that shows amounts (expressions) in different items (dimensions). What I want to show is the total amounts of each row (right side) and each column (bottom side).

Is possible to do that??, if possible, How can I do it?

Many thanks in advance.

Mauriccio

[#2]

Hi,

If you turn on partial sums on the presentation tab of properties, you will get the totals at the bottom of each column. Then if you simply pivot one of your dimensions, you will get the matching totals to appear on the right hand side.

I hope this helps

Thanks

Nick

[#3]

Dear Nick,

Many thanks for your advice.

Actually, I have done what you suggest and it works fine for the columns, however when I pivot one of my dimensions, it doesn't appear total amounts for rows at all.

Do you know why?

Mauriccio

[#4]

Hi Mauriccio,

Do you have partial sums set for all of the dimensions?

Thanks

Nick

[#5]

Dear Nick,

Good point!!, now it works perfectly. Many thanks mate!!...

Mauriccio