topic Re: How to calculate subtotal ? in QlikView

How to calculate subtotal ?

Wed, 04 Mar 2015 13:05:41 GMT

Hello everyone,

I currently have a pivot table looking like this :

City Product quantity

Paris A 2

Paris B 1

London C 3

London B 4

City and Product are dimmensions whereas quantity is an expression (sum(count_s)).

I would like to get subtotal for the city, something like this :

City Product quantity

Paris A 2

Paris B 1

Paris Total 3

London C 3

London B 4

London Total 7

Thank you for help

Have a good day !

Laura

Anonymous — Wed, 04 Mar 2015 13:07:17 GMT

go to presentation tab, choose your dimension and check "show partial sums".

Marc.

Anonymous — Wed, 04 Mar 2015 13:08:18 GMT

Hi,

In the presentation tab, Select your dimension and check "show partial sums" Option ..

renjithpl — Wed, 04 Mar 2015 13:10:09 GMT

Have you tried

Under the Presentation tab select City dimension check the "Show Partial Sums" ?

Wed, 04 Mar 2015 13:11:30 GMT

thank you ! I had tried it but instead of selecting "Product", I was tryin with city...