Thank you! You've been incredibly helpful!

With the same spreadsheet - how do you use a pivot table to track the percentage of quotes that were awarded? Or am I wrong in thinking that can be done?

I'd love to learn more about this program. I'm disappointed there are in depth classes available any more. (at least not that I've been able to find... maybe I'm looking in the wrong place...)



Thank you again for all your help!

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.

Attached Files

Fab Estimator Chart-test.xlsx (29.8 KB, 9 views)

I was wanting something more along the lines of what percentage were awarded/lost/unknown vs total number quoted each month.