Creating standard columns
A standard column displays a specific value and its operators. A standard column is not calculated. You can add dimension filters to limit the data that is displayed in the column.
- Select My Reports > Report Designer.
- On the Column Views tab, select a column view record.
- In the Column List section, click Create.
- In the Column Type field, select Standard.
-
Specify this information:
- Column Value
- Select the measure to use for the column value. If additional period operators
are required, then click Add
Operator To Field.Note: If additional period operators are not required select a measure from the list and select Ok.
- Offset Padding
- Specify the number of additional spaces to include between columns.
-
- Number of Decimals
- Specify the number of decimals for amount values.
- Show Column On Report
- Clear this check box to omit the column from the report.
- Show Column Header
- Clear this check box to hide the column heading.
- Show As Percentage
- Select this check box to show amount values as percentages.
- Suppress Commas
- Select this check box to omit commas in amount values.
- Click Save.
- In the Dimension Filters section, click Create.
- Select a Dimension.
- Click Save.
- Click Add Dimension Filter. You must add at least one filter.
- Select a filter value. For some dimensions, you must select a structure and an element within the structure.
-
Click Submit.
Optionally, select the Column Views tab, select a Column View and navigate to the Associated Reports tab to show reports associated with column views.