Change Attributes

Sample Screen

Description

This dialog box allows you to change the attributes displayed in a pivot table and the order in which they are nested.

Note – Pivot tables can include between two and seven attributes.

This dialog box appears when you click the Change Attributes icon on the Pivot Table Toolbar.

Screen Fields

Available Attributes

List of all attributes to be hidden from the pivot table. Select one or more attributes you want to move to the Selected Attributes list. This field supports multi-select.

Selected Attributes

List of all attributes to be included in the pivot table. The last attribute in the list appears on the column edge of the table. The other attribute(s) appear on the row edge, nested in the order they appear in the list; the top attribute is the outer layer.

Select one or more attributes you want to either move to the Available Attributes list or re-order in the nesting. This field supports multi-select.

Note – This list must contain a minimum of two and a maximum of seven attributes.

Buttons

Selection arrows

Active buttons depend on whether you have selected items in one or both lists.

or	Move the selected item(s) to the indicated list.
or	Move all items from one list to the other.

Ordering arrows

These buttons are active only if you have selected one or more items in the Selected Attributes list.

or	Move the selected item(s) up or down, one place at a time.
or	Move the selected item(s) to the top or bottom of the list.

OK

Click to apply your entries.

Cancel

Click to dismiss this dialog box without applying your entries.