Discussion Board for collaboration related to Creating Analytics for QlikView.
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 :
Paris Total 3
London Total 7
Thank you for help
Have a good day !
Go to Solution.
go to presentation tab, choose your dimension and check "show partial sums".
In the presentation tab, Select your dimension and check "show partial sums" Option ..
Have you tried
Under the Presentation tab select City dimension check the "Show Partial Sums" ?
thank you ! I had tried it but instead of selecting "Product", I was tryin with city...