Pivot table display

I am having a whale of a time with my pivot table on the Summary sheet in the attached Transcript.xlsx file. The table should look like the Transcript 2.xlxs file. What I am after on that pivot table is that no matter how I sort or filter the information, Field, Course, and Description are on the same row. In other words, those three are a group. How do I accomplish this in a pivot table?

Also, how do I lighten the shade of a fill color?

TS

Thanks, Jete! This looks much better and does what I want it to do.

I now need two things:

1) How do I take the "Points" calculation from the data table "Grades" and make it a calculated field in the PivotTable "Transcript"? I cannot get the formula to return anything but 0. Is there a cleaner way of writing a nested IF/OR Statement?

2) Instead of displaying "Sum of Points," how do I get the PivotTable to display the actual value? I cannot drag "Points" into the Rows or Columns.

3) I need to add a "GPA" calculation to the Subtotal and Grand Total rows in the PivotTable. The formula would be

Formula:

=SUBTOTAL(Points,9)/SUBTOTAL(Hours,9)

and

Formula:

=SUBTOTAL(Points,109)/SUBTOTAL(Hours,109)

How do I do this?

Many thanks,
Terrible Tim

I'm sorry, but you are close, but not quite because I was not clear. I want to take the "Points" field out of the data table and make it a calculated field in the PivotTable. And, "GPA" should only be displayed in the Subtotals and Grand Totals rows. "Sum of GPA" should not be displayed at the end of every line. The value for "Points" goes at the end of every line.