I have created a pivot table with a total row at the bottom as well as a total column at the right.
I need to create a "%" row at the bottom, below the total row, using the total of the individual column divided by the total of the total column.
Becuase there is a filter for the pivot table this percentage row needs to be dynamic as the number of both rows and columns will change when the filter is changed. Would welcome any advice on how to do this.
Thanks.