If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

Question

Quizplus · Accepted Answer

When you drag a field to the Filters area of a PivotTable, it creates a filter for that field, allowing you to filter the data in the PivotTable based on the values in that field. In this case, dragging the Department field to the Filters area would create a filter for the Department field, allowing you to filter the PivotTable by Department.

If a PivotTable Displays the Department and Quarter Fields as Row