Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to add grand total for expression at the bottom of a pivot table

Hi, how do I add a grand total row for each column in a pivot table? I want exactly like the one below. I have tried using the 'show partial sums' option but it does not create a row at the bottom to show total for each column but it creates another column beside each sector. Thanks!

Shift

Sector 1

Sector 2

Sector 3

Day

1

2

4

Night

2

5

2

Day

3

3

1

Grand Total

6

10

7

4 Replies
Not applicable

Re: How to add grand total for expression at the bottom of a pivot table

Try the 'Show Partial Sums' on Shift instead of Sectors.

Kind regards

jebamalai
Valued Contributor

Re: How to add grand total for expression at the bottom of a pivot table

If you want the exact summary like this then I would suggest you to go for a straight table and put the results in bottom

anbu1984
Honored Contributor III

Re: How to add grand total for expression at the bottom of a pivot table

If it is showing as separate column, then click on Totals column and drag & drop at the bottom.

anbu1984
Honored Contributor III

Re: How to add grand total for expression at the bottom of a pivot table

Pivot table with Total as column, row.png

Community Browser