1. User's Guide
  2. Tables
  3. Modify a Pivot Table
  4. Change Pivot Table Attributes and Nesting Order

Change Pivot Table Attributes and Nesting Order

Choose which attributes to display in the pivot table. Change the order in which they are nested.

  1. Click Change Attributes Change Attributes icon in the pivot table toolbar.
  2. Select an attribute (shift- or ctrl-click to select multiples).

    Use the left and right arrows to move the attributes between the Available and Selected lists. Use the up and down arrows to order the selected attributes.

    Pivot tables can have between two and seven attributes.

    Sample change attributes dialog with arrows noted.
  3. Verify the attributes you want are in the Selected Attributes list and in the proper order. Click OK.