Discussion Board for collaboration related to QlikView App Development.
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 presentation tab, choose your dimension and check "show partial sums".
View solution in original post
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...