0
I work for a Helpdesk and I am trying to create a pivot table that shows the resolution rate of our analysts. This is the pivot table I currently have shows each analysts name on the left and the data in the table is the number of tickets that we created. On the top of the pivot table, the only field I have is split into two columns, Dispatched and Resolved.
What I am trying to do is add another field that basically shows their resolution rate or Resolved/Grand Total. If someone could point me in the right direction it would be greatly appreciated.
I think the problem lies in the fact that the orginal table has HD Resolved as the Field name and the options in this field are wither Resolved or Dispatched. I cannot seem to say just display a count of the tickets that are dispatched or that are resolved since they are included in the HD resoloved field. – fastrack20 – 2011-05-31T13:42:23.117