topic Re: Re: How to add total in Pivot Table? in QlikView

How to add total in Pivot Table?

soha1902 — Mon, 01 Sep 2014 05:51:00 GMT

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....

Re: How to add total in Pivot Table?

ashfaq_haseeb — Mon, 01 Sep 2014 05:57:57 GMT

Hi,

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

Regards

ASHFAQ

Re: How to add total in Pivot Table?

soha1902 — Mon, 01 Sep 2014 06:00:29 GMT

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

Re: How to add total in Pivot Table?

PrashantSangle — Mon, 01 Sep 2014 06:00:56 GMT

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

Re: How to add total in Pivot Table?

soha1902 — Mon, 01 Sep 2014 06:03:10 GMT

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..

Re: How to add total in Pivot Table?

ashfaq_haseeb — Mon, 01 Sep 2014 06:04:30 GMT

Then you need to drag dimension to top horizontally.

If possible attach a sample.

Regards

ASHFAQ

Re: Re: How to add total in Pivot Table?

ashfaq_haseeb — Mon, 01 Sep 2014 06:35:04 GMT

Hi,

have a look at attached application

Regards

ASHFAQ