Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
go to presentation tab, choose your dimension and check "show partial sums".
Marc.
go to presentation tab, choose your dimension and check "show partial sums".
Marc.
Hi,
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...