Struggling to create % of Fails in pivot tables

[phillipscrfc]

Hi All

I have some raw data that I receive daily that from a QA perspective has 31 potential questions that we evaluate our staff on. These are either N/A, Pass or Fail depending on the case type.

I can pull the over number of fails etc but through pivot table i cannot generate the %fail of each question for each agent in a table.

Any help would be appreciated.

 

[GlennUK]

Your data is better suited to having a formula in a column to the right of the data that calculates the percentage you want.