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

1. Click Change Attributes 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.

   
   

   

   
   
3. Verify the attributes you want are in the Selected Attributes list and in the proper order. Click OK.