Specify the display order of item properties

Office PivotTable

Specify the display order of item properties

  1. Click the field whose item properties you want to order.
  2. On the toolbar in the PivotTable list, click Commands and Options , and then click the Item Properties tab.

    The order in which the properties are listed in the Item properties box is the order in which the properties are displayed in the report or ScreenTips.

  3. Select the property that you want to display at the top, and click Up until the property appears as the first item in the list.
  4. Order the rest of the properties by clicking Up or Down.

Note   If new properties are added after you order the list, the new properties will appear at the end of the list until you reorder them.