Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Shahzad_Ahsan
Contributor III

Grand Total and Sub Total in Pivot Table

Hi Everyone

I need Grand Total and Sub Total in pivot table.(Like attachment)

When I check 'Indent Rows' in presentation tab then Sub Total appears, but how can I get Grand Total on top.

I am using Qlik Sense November 2017 version.

pivot_subtotal_row_percent.png

1 Solution

Accepted Solutions
Highlighted
jwjackso
Valued Contributor

Re: Grand Total and Sub Total in Pivot Table

Edit the pivot table and in the right panel select the first dimension.  Turn on "Show Totals".

View solution in original post

2 Replies
Highlighted
jwjackso
Valued Contributor

Re: Grand Total and Sub Total in Pivot Table

Edit the pivot table and in the right panel select the first dimension.  Turn on "Show Totals".

View solution in original post

Highlighted
Shahzad_Ahsan
Contributor III

Re: Grand Total and Sub Total in Pivot Table

Hi Jerry

Thanks

This is working. I was not knowing that 'Show Totals' is on first dimension.