Specify the display order of item properties

Office PivotTable Lists

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 Button image, 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 UpUp arrow until the property appears as the first item in the list.
  4. Order the rest of the properties by clicking UpUp arrow or DownDown arrow.

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.