topic Re: subtotal in pivot table in QlikView

subtotal in pivot table

kunkumnaveen — Mon, 04 Jan 2016 06:25:42 GMT

Hello All

i am trying to create a pivot table with subtotals in it ,i manage to get total by enabling the check box show partial sum ,now i am trying to get subtotals for a dimension(country) please find the attachment(sheet2)

thanks in advance

naveen

Re: subtotal in pivot table

Mon, 04 Jan 2016 13:32:10 GMT

Hi ,

Do you want to see the total like pic ?

Re: subtotal in pivot table

mambi — Mon, 04 Jan 2016 13:43:53 GMT

you can use this : sum(TOTAL <Country> Sales)

Re: subtotal in pivot table

settu_periasamy — Mon, 04 Jan 2016 13:58:16 GMT

Hope you already checked the 'Partial Sum' for Country Dimension also.

In your attachment, Already shows the Country based Total in the Pivot Table.

If you want the "Grand Total" On Top, Just check 'Subtotals on Top' in the presentation Tab.

Re: subtotal in pivot table

Mon, 04 Jan 2016 14:08:25 GMT

The employee details table is currently showing subtotals by country??

Re: subtotal in pivot table

kunkumnaveen — Tue, 05 Jan 2016 04:23:14 GMT

Hello senthil thanks for making time and replying to my query ,yes i trying to make replica of those sheets by using the same data and same objects

Re: subtotal in pivot table

kunkumnaveen — Tue, 05 Jan 2016 06:23:35 GMT

Hello Adam,the attached document was my task i need too create replica of that thankyou