You create a PivotTable to summarize average Grade by Department and Semester . How should you arrange the fields?

Question

You create a PivotTable to  summarize average Grade by Department and Semester . How should you arrange the fields?

Accepted Answer

Rows: Department; Columns: Semester; Values: Average of Grade

Answer

Rows: Department; Columns: Grade; Values: Average of Semester

Answer

Rows: Semester; Columns: Department; Values: Sum of Grade

Answer

Rows: Course; Columns: Semester; Values: Count of Student ID

Crowdly