Break Grouping
When you have multiple dimensions on the categories axis, use Break Grouping to ignore the grouping order and change how the dimensions and measures are sorted.
To enable or disable Break Grouping, from the chart action menu (
) select 
Sort 
Break Grouping
.
Example
You have a Profit and Loss model with the following measure and
dimensions:
| Type | Name |
|---|---|
| Dimension | Product |
| Dimension | Region |
| Measure | Income Statement |
Sort on Product (A-Z), with the Break Grouping option disabled
|
Region |
Product |
Income Statement (millions) |
|---|---|---|
|
New York State |
Basics |
0.63 |
|
New York State |
Juices |
16.97 |
|
New York State |
Softdrinks |
16.14 |
|
Ohio |
Basics |
0.06 |
|
Ohio |
Juices |
2.22 |
|
Ohio |
Softdrinks |
1.69 |
|
Pennsylvania |
Basics |
0.25 |
|
Pennsylvania |
Juices |
5.94 |
|
Pennsylvania |
Softdrinks |
7.24 |
Sort on Product (A-Z), with the Break Grouping option enabled
|
Region |
Product |
Income Statement (millions) |
|---|---|---|
|
New York State |
Basics |
0.63 |
|
Ohio |
Basics |
0.06 |
|
Pennsylvania |
Basics |
0.25 |
|
New York State |
Juices |
16.97 |
|
Ohio |
Juices |
2.22 |
|
Pennsylvania |
Juices |
5.94 |
|
New York State |
Softdrinks |
16.14 |
|
Ohio |
Softdrinks |
1.69 |
|
Pennsylvania |
Softdrinks |
7.24 |