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!