topic Re: Pivot Table Total in QlikView

Pivot Table Total

Thu, 04 Sep 2014 08:20:15 GMT

Hello,

I made a pivot table for invoicing monthly costs. Attached is the screenshot for May. As you can see, cost centers, projects, and the month are displayed as columns, whereas each team is presented on the top horizontally (required by the management). I would like to add a total for each project and each team at the end of each row/column, but I couldn't get it right. The option "Total mode" in the expression tab is grey, which means I can only crack this from the expression itself, I suppose.

My current expression is simply sum(Allocation_Amount), and the field names for project and team are Project_Name and Party_Name, respectively. Please help me with it. Thank you very much in advance.

Regards,

Tuan

Re: Pivot Table Total

MK_QSL — Thu, 04 Sep 2014 08:33:48 GMT

Go to presentation tab

Select your Dimensions

Tick Show Partial Sums

Re: Pivot Table Total

ashfaq_haseeb — Thu, 04 Sep 2014 08:37:48 GMT

Go to chart properties --> Presentation tab --> Select your dimension --> and now select show partial sum.

Regards

ASHFAQ

Re: Pivot Table Total

Thu, 04 Sep 2014 08:39:06 GMT

Hi Manish,

Thanks for the suggestion. It's ALMOST what I wanted to achieve, except that it shows a total at every level...Is there a way to only show a grand total? (i.e. only the last row and column as shown in the attachment below.) Thanks!

Re: Pivot Table Total

Thu, 04 Sep 2014 08:40:39 GMT

Hi Ashfaq,

Thanks! But is there a way to show only grand total? Please see my reply to Manish above to see the current result. Thanks!

Re: Pivot Table Total

ashfaq_haseeb — Thu, 04 Sep 2014 08:41:14 GMT

Then click show partial sum for costcenter number only.

Uncheck for others.

Regards

ASHFAQ

Re: Pivot Table Total

Thu, 04 Sep 2014 08:43:33 GMT

Thanks a lot! Works perfect now!

Re: Pivot Table Total

ashfaq_haseeb — Thu, 04 Sep 2014 08:44:10 GMT

Welcome

Regards

ASHFAQ