| Hierarchies Pattern Set |
| Pivot Table | Version 2.0.0.0 |
||
|
|||
| Description | |
| 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 | |
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 |
No |
No |
Yes |
| Pattern Sample | |
 |
| Figure 1. Viewing hierarchies by rows and columns |
| For more information, see the Pivot Table guidelines. |
| Related Guidelines |
| Pivot Table Usage Guideline | Enables view of two hierarchies at the same time |
