I have a large set of data that has ticket information, when created, account, who worked it, when closed, etc. One of the columns is SLA Resolution Met, and it's Yes/No/Blank. What I would like to do is have a pivot table with the engineer assigned, and the month ticket was completed, and show the percentage of SLA Resolution Met. Currently when I create a pivot table it just does a count. Trying to use the show values as options don't get what I need. What I would like it to show is columns of engineers, headers of Months, and the data would be % of tickets in that month by engineer that were resolved (Yes) within SLA. The reason I am doing this as a pivot table instead of formulas, is to make my metrics more manageable. This is just one metric out of many that I am tracking, and doing it all with formulas takes forever to updated and locks up Excel for 10+ minutes. It is a large data set.
Any help is appreciated.
Thanks
Bookmarks