How to add total column on pivot table ?

[paulyeo11]

Hi All

I have a pivot table , which compute Exp type by month.

with michael help , i manage to display the Total Row at the top. So now i can view the month total exp amount.

Now i need to display Column total. can some one help me. So that i can display which is overall total amount on exp type for last 2 year.

Paul

[kumarnatarajan · Accepted solution]

Hi,

1. Go to presentation tab

2. Select your dimensions (what level you want sum)

3. Then click "Show partial Sum" check box

see the below screenshort.

[paulyeo11]

Thank you kumar

[#4]

Hi Kumar,

I wanted to have sum of the Quarter filed (Which I used as dimension). Follwed ur steps as u mentioned here and it worked as expected. But the problem is for the Total Column(Partial Sum), am getting the font color of the field as well as the values in Bold and the background for this column in Grey.

I want the field values to be displayed in regular color and the background should be white.

Please advise.

Thanks & Regards,

Sonali