A script enabled browser is required for this page to function properly.
Skip to main content
STA User Interface Guide, v1.0.2
E28380-03
Table of Contents Previous Next Index


Table Displays : Pivot Table Layout Tasks : ▼ Change Table Attributes and Their Nesting Order

▼

Change Table Attributes and Their Nesting Order

Use this procedure to change the attributes displayed in a pivot table. You can add and remove attributes in the table and change the order in which they are nested.

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

1.
In the Table Toolbar, click the Change Attributes icon.

The Change Attributes dialog box appears. The Selected Attributes list identifies the attributes currently included in the pivot table and their order. The Available Attributes list identifies attributes that are currently hidden.

2.
Arrange the attributes so that the ones you want to display are included in the Selected Attributes list and the ones you want to remove are in the Available Attributes list.

Note – The Selected Attributes list must include a minimum of two and a maximum of seven attributes.

a.
Select the attributes you want to move from one list to the other. This dialog box supports Multi-select.
b.
Click an arrow to move the items, as follows:

  or  

Move the selected item(s) to the indicated list.

  or  

Move all items from one list to the other.
c.
Repeat this process until both lists include the items you want.
3.
Optionally, you can reorder the items in the Selected Attributes list by using the reorder arrows on the right side of the dialog box.

By default, the last attribute in the Selected Attributes 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.

a.
Select the items you want to move. This dialog box supports Multi-select.

b.
Click an arrow to move the items, as follows:

  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.

c.
Repeat this process until the Selected Attributes list is arranged the way you want.
4.
Verify that the dialog box is arranged the way you want, and then click OK.

The pivot table is updated according to your selections.

Table of Contents Previous Next Index Link to documentation
Copyright © 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices