How to add total in Pivot Table?

[soha1902]

Hi all,

I am using one Pivot table to show the data. I am pivoting two dimensions Month and Year. Now my requirement is to show the Total on right side of the table. Please find excel file in attachment. In the same format I want to show in QV.

I am using three expressions and based on  condition only one expression can selected at a time.

Plz help....

[ashfaq_haseeb]

Hi,

Go to chart  --> Properties --> Presentation tab --> and select dimension --> select show partial sum.

Regards

ASHFAQ

[soha1902]

Like This Total column I want to add in my Report.

[PrashantSangle]

Hi,

You can do this by go to Presentation tab->select dimension for which you want to find total-> show Partial Sum

and from Subtotal tab-> select sub total at bottom.

Regards

[soha1902]

Hi Ashfaq,

If I select dimension then its showing left side and not properly what I want. I just now added one screenshot in my reply. Plz guide me how to do this.

Thanks for you repply..

[ashfaq_haseeb]

Hi

Then you need to drag dimension to top horizontally.

If possible attach a sample.

Regards

ASHFAQ

[ashfaq_haseeb · Accepted solution]

Hi,

have a look at attached application

Regards

ASHFAQ