topic Re: Sub Total Pivot table in QlikView

Sub Total Pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a pivot table.

I have changed the rows to columns and columns to rows.

I want to display the total of each column and each row.

Please suggest

Re: Sub Total Pivot table

devarasu07 — Wed, 01 Nov 2017 03:31:47 GMT

Hi,

Try to enable partial sum on your row/column dimension @ pivot chart object presentation properties like below screen

Re: Sub Total Pivot table

Anonymous — Thu, 02 Nov 2017 02:44:27 GMT

Thanks for reply.

Now I am able to see the row total.

How can I also display column total.

Re: Sub Total Pivot table

madhumitha — Thu, 02 Nov 2017 02:48:30 GMT

Hello Dinesh,

Total will show you both the row and column total. If you refer Devarasu's screen shot, the top row in bold is column total. You can also bring it down by selecting the radio button "show sub totals at bottom"