Synthetic Dimensions - ValueList() (Example)

    It can be difficult to achieve a satisfactory presentation of analysis where it is necessary to get more than one measure (Sales, Budget, Forecast) into a chart with calculated date dimensionality.

    The ValueList () function returns a set of listed values which, when used in a calculated dimension, will form a synthetic dimension. In charts with a synthetic dimension created with the valuelist function it is possible to reference the dimension value corresponding to a specific expression cell by restating the valuelist function with the same parameters in the chart expression.

    This is great for creating more complex chart/tables for reports.