Quote:
Originally Posted by Nanaia
With the same spreadsheet - how do you use a pivot table to track the percentage of quotes that were awarded?
|
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.