Calculated dimensions
You can use expressions to create calculated dimensions. A calculated dimension consists of an expression involving one or more fields. All standard functions may be used.
There are cases when calculated dimensions are powerful in data analysis, for example, if you want to generate the dimensions values during analysis, when dimension values are dependent on the selections.
Calculated dimensions are also useful if you want to modify a field.
Once you have created a calculated dimension, you can use it as any other dimension.
Example:
You have a field called
Syntax:
If ([Calendar Month] <7, [Calendar Month], 'Rest')