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.