How to subtotal first column of pivot table in Qlikview

[posywang]

Hi,

Can anyone tell me how to subtotal first column of pivot table in Qlikview? Using "Show Partial Sums" only gives me Grand Total at the bottom. Please see example below. I'd like to subtotal by Product, which is the first column of the pivot table. Is it something that can be done in Qlikview? Thanks!

[sunny_talwar]

On the presentation tab select Color dimension on top left and then select 'Show Partial Sums' once again. You will need to repeat this for each dimension you want to show partial sum for

[awhitfield · Accepted solution]

Hi Xia,

you can achieve this using Partial Sums, see the screen shot and simple example attached.

HTH Andy

[HirisH_V7]

Hi,

Is this you require,

-Hirish

[Anonymous]

Hi,

Right Click Pivot Table> Presentation tab>Select which column you want to see Subtotal>Below opt " Show Partial Sums"

Hope it helps!