Optional, highlight, or compare by dimension—Financial Report Writer

Use the Columns tab to specify the number of report columns, the type of value you want to in each column, and the reporting periods for which you want data.

The order in which the tabs appear in the Financial Report Writer can’t be changed.

You have multiple options for creating column comparisons by location, department, or other dimensions. The options that you'll see depend on other options you've selected in the report writer.

  • Expand by dimension:
    You can expand a single column by dimension, such as location. Learn more about how column expansion works.

    Quarter ending

    Sep 30

    displays

    Los Angeles

    Quarter ending

    Sep 30

    New York

    Quarter ending

    Sep 30

    All Locations

    Quarter ending

    Sep 30

    Quarter expanded by dimension (Locations)

  • Filter a column by dimension structure:
    Instead of looking at all members of a dimension, you can use dimension structures to filter for selected members, or members that meet certain criteria.
  • Filter and expand by a hierarchical dimension structure:
    For more complex analysis, use a hierarchical dimension structure to create columns to organize your data.

Next step: Select the account group