Originally Posted by gebobs

The percentage of the number of quotes or of the shop hours? Or something else? Do you want them as a percentage of the total for each month or of the grand total.



Any of these is possible, I think. See attached. I did percentage of shop hours by status for each month. All I did was add another Shop Hours to the Values section of the pivot fields. Click on it and select Value Field Settings and make sure it's a sum. Then go to the Show Values As tab and select % of Column Total. A lot of them are blanks which you can filter out if you don't want them to be in the calculation.