Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

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
jwjackso
Contributor III

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".

2 Replies
jwjackso
Contributor III

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".

Shahzad_Ahsan
Contributor II

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.

Community Browser