Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try the 'Show Partial Sums' on Shift instead of Sectors.
Kind regards
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
If it is showing as separate column, then click on Totals column and drag & drop at the bottom.