The Breakout value option is available when you select the right-click menu, and the currently active cell contains an XL3Lookup function, an XL3ValueRankLookup function, or a grid data cell.
The Breakout value option allows you to explore and break down interesting data. For example, take a cell showing Reseller Sales Amount for the United States region in 2003. If you break this out by product, then the result is the top 10 products for the United States region in 2003. You can then break the items out by another hierarchy to analyze them more deeply.
- Right-click the cell to analyze.
- Select Break Out from the menu.
- Enter these details. The result is inserted into the sheet.
| Property | Description |
| Position to insert breakout | Specify the starting cell on the spread sheet where the breakout values are to be inserted. |
| Hierarchy to breakout | Select a dimension to use to break out the cell value. |
| Show top or bottom members and Breakout count | Determine the number of rows of breakout information that are generated, and whether they should be of the highest or lowest-ranked members. |
| How to breakout hierarchy | When breaking out from a grid — choose a selection from the breakout hierarchy. |
| Rank by selection | When breaking out a formula — choose a selection from the breakout hierarchy. |
| Show percentages | Include a % column to show the item's contribution to the parent value. |
| Track active cell | |
| Display percentage bar | Include an in-cell bar to represent the % value. |
| Include 'Others' grouping | If breaking out to display the top 5 members, this option will create an Others grouping to group all the items outside the top 5. |
| Exclude zeros | Exclude members with a 0 value from the breakout. |
| Exclude nulls | Exclude members with no values from the breakout. |
An item in the Breakout can then be further broken out.
Track active cell
When Track active cell is enabled, selecting another data value in the source grid updates the breakout values to reflect that selection. The active cell is highlighted to show the current selection.
Breakout of United States, CY 2001.
