Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country | Jan | feb | mar | apr | Grandtotal |
a | 2 | 4 | 5 | 2 | 13 |
b | 5 | 1 | 2 | 4 | 12 |
c | 1 | 2 | 5 | 3 | 11 |
Grand total | 8 | 7 | 12 | 9 | 36 |
How to create row wise grand total in pivot table?
In the screenshot below, enable 'partial sums' checkbox for both country and month.
You can also change 'label for totals' as well.