Split a row by a Dimension (Segment by)
- Ask Ari
- By hand
Break Revenue down by Region on the P&L table.
Collapse or expand a breakdown
Select the arrow beside a row name to collapse the rows under it, and select it again to expand them. Shift-click the arrow, or ⌘-click it on a Mac, to do the same for every row at its level under the same parent, such as each department under Revenue. You can also right-click the row and choose Collapse child rows or Expand child rows. Collapsing changes only your own view, and your browser remembers it for up to 200 blocks; see Limits. You cannot set a breakdown to start collapsed for everyone who opens the table. Column groups collapse the same way, with the arrow in the group’s header; see Show, hide, or pin total columns.Remove a breakdown
Right-click the Dimension’s label row, such as REGION, and choose Remove dimension. The rows leave this table; the Variable’s values stay in your Model. When this is the Dimension’s last row, column, or drill-in on any table, cfo.ai first asks Delete variable or dimension?, and choosing Delete completely deletes the Dimension from your Model; see Build a Table block by hand.See the inputs behind a calculated number (Drill in)
Drill in shows what a calculated number is made of without changing the table.- Point at the row name of a calculated row, such as Payroll, and select the magnifier button, Drill in.
- The rows its formula reads, such as Headcount and Salary, open beneath it on a hatched background. Drill in on one of them to keep tracing. For a Variable that reads a connected system, drilling reaches the source records, such as the individual transactions.
- Select Clear drill-in on the row to close them, or right-click and choose Remove all drill-in rows.
Add an item to a Dimension
An item is one entry of a Dimension, such as West in Region.- At the end of a breakdown’s items, select the + button, Create Region item. Type the name and press Enter.
- Or right-click the Dimension’s label row, such as REGION, and choose Create Region item. From an item, the same entry is under Region dimension settings.
- Or point at the left edge of an item row, select Insert row below, type the name, and press Enter.
Rename an item
Double-click the item’s name, or right-click it and choose Rename. Type the new name and press Enter. You can rename only items you created; items that come from a connected system keep their source name. A rename also updates the formulas, filters, drill-ins, and charts that use the item, and a notice counts what it changed.Delete or hide an item
To delete an item you created, right-click it on the table where the Dimension was created and choose Delete Region item.- An item nothing uses is deleted at once. The notice that confirms it offers Undo.
- An item that formulas, filters, or other tables still use opens Delete item?, which lists what the deletion changes. Choose Cancel, or Delete anyway. Deleting also removes the values typed into the item’s row, which cfo.ai stores as formulas for that item alone.
Choose which combinations of items appear
A breakdown can show only the items and combinations that have data, such as the products each region sells, or every combination. Right-click the Dimension’s label row and choose Segment generation:- Show only matching segments shows only the combinations that have data. This is the standard choice.
- Expand to create all segments shows every combination, so you can type values into ones that have none yet, except in cells that come from a connected system. For a Dimension of numbers, also set Start Value and End Value; for a Dimension of dates, set Start / End dates. The range takes effect once both ends are set.