Skip to main content
Adaptive Planning
Last Updated: 2023-06-23
Reference: Crosstab Settings

Reference: Crosstab Settings

Appearance Settings

Section
Field
Description
General
Name
The chart title. Character limit: 50.
General
Show in Presentation Mode
Conditional Formatting
Add rule

Data Settings

Section
Field
Description
Columns
Accounts
Columns
Name
Columns
Account
Columns
Version
Columns
Filter
Columns
Display Units
Columns
Negative Number Format
Select how to display negative numbers in the chart.
Columns
Suppress Zeros
Hides columns that have all zeros.
Rows
Add
Expand the
Rows
section to view, change, delete, or add rows to the chart. You can add:
  • Time.
  • Dimensions, which include levels, custom dimensions, level attributes, and dimension attributes.
Rows
Suppress Zeros
Hides rows that have all zeros.

Time Settings

Section
Field
Description
General
Stratum
General
Span
General
Data Range
General
Pin Time (blue)
Set a fixed time period based on the selected strata. Example: For
Stratum
select:
Month
. Then:
  • For
    Single Period
    spans, set a specific month. Example: April 2017.
  • For
    Range
    spans, select the start and end months. Example: April 2017 to June 2017.
General
Unpin Time (gray)
Set time relative to the reference period displayed on the perspective toolbar and based on the selected strata.
  • Current
    : Matches the date selected for the perspective.
    Backwards
    : Adjusts backwards from the perspective date by the number that you enter.
  • Forwards
    : Adjusts forward from the perspective date by the number that you enter.
For
Single Period
time spans, set the relative time for the chart. For
Range
time spans, set the relative time for the start and end of the range.