I have a pivot table that shows A/R by the week it was calculated and the age of the claim. The column labels are the Week label (Current, Week 2, Week 3) and then the age of the claim 0-30 Days, 31-60 Days, etc. The row label is the insurance company who is paying the claim. I am doing grand totals on the columns, but I need to see the column grand total as a percent of the total grand total. For example, I can see that my "Current" 0-30 grand total is $345 and my "Current" 31-60 grand total is $35. But I need to know what % the 345 and 35 are of all of the "Current" grand totals. I can see my "Week 2" 0-30 grand total is $1083, and the 31-60 grand total is $75, but I need to know what % the 1083 and 75 are of all of the "Week 2" column grand totals. I know how to show an individual cell as a % of the row total, but can't seem to figure out how to do that for the grand totals row.
and welcome to Stack! It's very difficult to understand from your input exact details, so for future questions try to provide workbook sample / screen or at list part of meaningful data typed here. However, the solution seems to be pretty simple (assuming I understood the input correctly): right click on the field you want to change, select
Value Field Settings... and then select the option you need. For your needs I thing
% of total is the choice:
Hope that was helpful. In case you're happy with the solution - do not forget to tick the answer and therefore mark the thread solved. Good luck!