What can you do when you have two levels of data in PivotTable rows?
A) Add a calculated row to the PivotTable.
B) Use the Collapse and Expand buttons to drill down and up in the data.
C) Filter the PivotTable on two columns.
D) Create a 3-D PivotChart.

Question

Quizplus · Accepted Answer

Using the Collapse and Expand buttons allows you to drill down and up in the data to see the two levels of data in the PivotTable rows. This is the most efficient and user-friendly option. Adding a calculated row or creating a 3-D PivotChart may not necessarily help with displaying the two levels of data, and filtering the PivotTable on two columns may not provide the desired level of detail.

What Can You Do When You Have Two Levels of Data