Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Sub Total Pivot table

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

3 Replies
Master II
Master II

Hi,

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

Capture.JPG

Contributor
Contributor

Thanks for reply.

Now I am able to see the row total.

How can I also display column total.

Creator
Creator

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"