What dictates the order of hierarchy of fields in the rows of a PivotTable?
A)alphabetical order
B)the order of the fields in the ROWS area.
C)the order of the fields in the COLUMNS area
D)the rank in the sort order dialog box.

Question

Quizplus · Accepted Answer

The order of hierarchy of fields in the rows of a PivotTable is dictated by the order of the fields in the ROWS area. The first field placed in the ROWS area will be the top-level field, and each subsequent field will be a subfield of the previous field in the hierarchy. Therefore, the order in which you add fields to the ROWS area determines the hierarchy in the PivotTable. The other options listed do not affect the order of hierarchy in the PivotTable rows.

What Dictates the Order of Hierarchy of Fields in the Rows