Dimensionality - chart function
Syntax:
Dimensionality ( )
Return data type: integer
Limitations:
This function is only available in charts. The number of dimensions in all rows, except the total which will be 0, will be returned. For all chart types, except pivot table it will return the number of dimensions in all rows except the total, which will be 0.
Example:
A typical use for dimensionality is when you want to make a calculation only if there is a value present for a dimension.
Example | Result |
---|---|
For a table containing the dimension IF(Dimensionality()=3, "Invoiced"). |
|