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

[#1]

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

[#2]

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

Kind regards

[Anonymous]

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]

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

[anbu1984]