View Single Post
 
Old 12-21-2016, 01:51 PM
Nanaia Nanaia is offline Windows XP Office 2013
Novice
 
Join Date: Dec 2016
Location: Lexington, KY
Posts: 10
Nanaia is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
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.
I was wanting something more along the lines of what percentage were awarded/lost/unknown vs total number quoted each month.
Reply With Quote