Period operators can be added to limit the data in a column to specific periods or months.
- Select .
- On the Column Layout tab, select a Column Library record.
- In the Column Details section, open a column record.
- In the Column Definition section, Column Value field, click the search icon.
- Click Add Operator To Field.
- Specify this information:
-
Period Operator Category
-
Specify the period operator category.
-
Year Operator
-
Select the previous or following year.
-
Year Shift
-
Specify the number of previous or future years. If Year Operator is blank, then this field must be blank.
-
Period Operator
-
Select the previous or next period.
Note: This field will not appear if Period Range was selected in the Period Operator Category field.
-
Period
-
Select period, month, quarter, or year.
-
Number
-
A number that identifies the reporting period for this column. The values for the operator are displayed in the Field Preview field.
- Click Ok.