Question: The PivotTable below has one row field and two column fields. How can you pivot this table to show the column fields as subtotals of each value in the row field?
- On the PivotTable itself, drag each `Average` field into the row fields area.
- Right-click a cell in the PivotTable and select `PivotTable Options > Classic PivotTable layout`.
- In the `PivotTable Fields` pane, drag `Sum Values` from the `Columns` section to a location below the field in the `Rows` section.
- In the `PivotTable Fields` pane, drag each field from the `Sum Values` section to the `Rows` section.
Answer: The correct answer of the above question is Option C:In the `PivotTable Fields` pane, drag `Sum Values` from the `Columns` section to a location below the field in the `Rows` section.