I have a large pivot table in which I am trying to see the % of grand total across all cells. The cells show as the "Sum" value in pivot table as a default. I am trying to change all these cells in the table into "% of Grand Total". I am doing this by selecting all cells and right-clicking then going to "Show values as > % of Grand total". This is only converting the first column in the selected range into % of Grand Total, but not the rest. Is there a way to change all columns of the pivot table into % of grand total in 1 go?
I wouldn't even mind submitting a macro to run this.
I wouldn't even mind submitting a macro to run this.