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
Bookmarks