# Pivot table column grand total as percent of all grand totals

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: