Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

wdchristensen
Contributor III

Adding totals to a Pivot Table in QS April 2018

I am trying to get a grand total on a pivot table in Qlik Sense and I don't see an option in the properties. I suspect there is an option that I am not seeing. Any help would be greatly appreciated.

1 Solution

Accepted Solutions
Ivan_Bozov
Valued Contributor

Re: Adding totals to a Pivot Table in QS April 2018

Go to Rows -> Show totals

4 Replies
Ivan_Bozov
Valued Contributor

Re: Adding totals to a Pivot Table in QS April 2018

Hi! It should be under Data -> Columns -> Your measure -> Totals function -> Sum

wdchristensen
Contributor III

Re: Adding totals to a Pivot Table in QS April 2018

I don't see the "Totals function" under either of my measures. Please see screenshot below.

TotalFunctionMissing_01.png

Ivan_Bozov
Valued Contributor

Re: Adding totals to a Pivot Table in QS April 2018

Go to Rows -> Show totals

wdchristensen
Contributor III

Re: Adding totals to a Pivot Table in QS April 2018

Thanks Ivan for walking me through it!