What a Table Block calculates
Ask Ari to set:- Variables — which Variables appear, in what order, each becoming a row.
- Dimensions and time — how to segment those Variables by one or more business categories, or by a Date grain such as month or quarter.
- Window — the date range and grain a new table shows. Reconfiguring an existing table’s Variables leaves its window alone; change the window through presentation instead.
- Transpose — flip rows and columns, useful for a database-style list of items with attributes across the top instead of a wide row of dates.
How a Table Block is presented
Once a table calculates the right thing, ask Ari to adjust its presentation without touching the calculation:- Rename the block’s title.
- Columns — widths and whether the formula column is visible.
- Visibility — hide or show specific rows or columns without deleting them.
- Window — change the shown date range or grain on an existing table.
- Comparison — show another Scenario, or an earlier period, alongside the baseline. See Create and compare Scenarios.
- Sort — order an axis ascending, descending, or in a manual order you specify.
- Formatting — fill color, bold, italic, underline, strikethrough, and row indent, applied to a whole row, a whole column, or a specific cell.
- Transpose — layout only, the same table read the other way.