Good morning all,

I'm having a Pivot Table cosmetic dilema on Excel 2010.

I have a pivot table that was created to show the average scores for 3 different criteria. The row labels goes from the average grade per "test", then it cascades to average grade per section, and finally average grade per question.

It's set up how I want, except, I would like for the values to show the correct grade for each criteria. So for example, the score I have it set on right now is the average score per test form. Every label will have the same grade, it looks like this:

Row Label ----- Score
Test Alpha ----- 93.35%
Section A ----- 93.35%
Question 1 ----- 93.35

Everything equals 93.35%


I would like for to do this:

Row Label ----- Score
Test Alpha ----- 93.35%
Section A ----- 89.22%
Question 1 ----- 97.38%


The goal is to be able to do this without having to format the raw data. Heck, if I have to add another column for each score, that's fine, but I only want the correct grades to show.

I'm not sure if this is possible without having to do slicers, etc. Sorry for the long post, thanks for the help!