topic Re: Subtotal and Grandtotal in pivot table in QlikView

Subtotal and Grandtotal in pivot table

Thu, 22 Oct 2015 13:32:13 GMT

Hello everyone,

I have a pivot table with subtotal of the number of product by customer and I want to calculate the grand total of one product but for all custommer like theses screenshots:

I have this in QlikView:

and I want this ( in red )

How can I do this in the pivot table?

Thank you

Re: Subtotal and Grandtotal in pivot table

MK_QSL — Thu, 22 Oct 2015 13:35:19 GMT

Go to presentation tab.

select dimension and tick Show Partial Sums

Re: Subtotal and Grandtotal in pivot table

Anonymous — Thu, 22 Oct 2015 13:36:00 GMT

I think that you're short one checkbox. Try going to the Presentation tab of the chart property and checking the "Show Partial Sums" box for your first (Customers) dimension.

Re: Subtotal and Grandtotal in pivot table

rubenmarin — Thu, 22 Oct 2015 13:59:13 GMT

Seems you checked partial sums only for Product, check it also by customer.

BTW totals row can be set Up (Left) or Down (Right), so you can't show it Left and Down.