Dimensionality - chart function

Dimensionality() returns the number of dimensions for the current row. In the case of pivot tables, the function returns the total number of dimension columns that have non-aggregation content, that is, do not contain partial sums or collapsed aggregates.

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 UnitSales, you might only want to indicate an invoice is sent:

IF(Dimensionality()=3, "Invoiced").

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?