Plan Table Overview
The plan table consists of columns, rows, and cells.
Columns contain dimension values grouped together to establish a hierarchy. For example, your plan might contain the following column dimensions: Year, Quarter, Period. If your plan is configured to display measures as columns, the lowest level column represents the measure.
Rows contain dimension values. For example, your plan might contain the following row dimensions: Trial Balance 1, Trial Balance 2, and GLA. If your plan is configured to display measures as rows, the name of the measure is displayed in the row.
A table cell is uniquely identified by the combination of dimension values and a measure. For example, a cell might be defined as follows:
- Year: 2025
- Quarter: Q1
- Period: 001
- Trial Balance 1: Assets
- Trial Balance 2: Current Assets
- GLA: 1020 - Accounts Receivable
- Measure: Dual
- Value: 491,945.5
Depending on how the plan is configured, this might be displayed as Example Table Cell - Column Measure, Example Table Cell - Row Measure, or Example Table Cell - Tree View.
| Year | 2025 | ||
|---|---|---|---|
| Quarter | Q1 | ||
| Period | 001 | ||
| Trial Balance 1 | Trial Balance 2 | GLA | Dual |
| Assets | Current Assets | 1020 - Accounts Receivable | 491,945.5 |
| Year | 2025 | |||
|---|---|---|---|---|
| Quarter | Q1 | |||
| Trial Balance 1 | Trial Balance 2 | GLA | Measure | 001 |
| Assets | Current Assets | 1020 - Accounts Receivable | Dual | 491,945.5 |
| Year | 2025 |
|---|---|
| Quarter | Q1 |
| Period | 001 |
| Hierarchy | Dual |
 Assets |
491,945.5 |
|
Current Assets |
491,945.5 |
| 1020 - Accounts Receivable | 491,945.5 |
For more examples of plan tables, see Plan Structure Overview.
The plan table is displayed on the Plan Lines tab of a plan record. Depending on how your org is set up, the plan table might also be displayed on the record page of a related record, for example, an account, an Accounting company, or a project.
The plan table represents a single scenario
Represents an independent scenario, version, or snapshot of a plan. of the plan. For more information, see Plan Scenarios.
Working with the Plan Table
If you have read and write access to a plan, you can perform the following column-level actions:
- Insert a new column
- Insert a new total column
- Reorder columns
- Apply a Planning unit to a column
- Update a column from the latest data from Analytics - this only applies if the plan was created from a data source
- Delete a column
If you have read and write access to a plan, you can perform the following row-level actions:
- Insert a new row
- Insert a new total row
- Reorder rows
- Apply a Planning unit to a row
- Update a row from the latest data in Analytics - this only applies if the plan was created from a data source
- Allocate amounts across the cells in a row
- Delete a row
If you have read and write access to a plan, you can perform the following cell-level actions:
- Enter a numeric value
- Add a formula to a cell to calculate the value dynamically
- Apply a Planning unit to a cell
- Add new comments to a cell
- View existing comments in a cell