Pivot Table Version 2.0.0.0Print this Page
Hierarchies Pattern Set
 
Description
Return to Top
The Pivot Table pattern displays hierarchies by row, column, or both. The Pivot Table pattern is the only pattern that can show two separate hierarchies at once. Tree tables have functionality similar to pivot tables, but tree tables are not able to show column-based hierarchies. The Pivot Table pattern is appropriate when analysis is a primary user task.
 
Pattern Set Decision Table
Return to Top
 
Categorized Content
Tree Table
Tree/Detail
Overview/Tree/
Detail
Pivot Table

How many levels of hierarchy within a data set do you require?

4+

3 – 7

4+

3+

3 – 7

What is the maximum number of levels that you need to display?

2

3 – 7

4+

3+

3 – 7

How many data dimensions (columns) do you require?

1

2+

2+

3+

2+

What is the user type?

Casual

Trained/Power

Trained/Power

Experienced

Power

Is analysis of trends a primary user task?

No

No

No

No

Yes

Do you want to enable users to open or close branches?

No

Yes

Yes

Yes

Yes

Are objects sortable within groups?

No

Yes
(sort retains hierarchy)

No

No

Yes
(sort retains hierarchy)

 
Pattern Sample
Return to Top
Figure 1. Viewing hierarchies by rows and columns
For more information, see the Pivot Table guidelines.
Related Guidelines
Return to Top
Pivot Table Usage Guideline Enables view of two hierarchies at the same time
 
About Oracle | Legal Notices | Terms of Use | Your Privacy Rights