Secondarydimensionality

Secondarydimensionality() returns the number of dimension pivot table rows that have non-aggregation content, that is, do not contain partial sums or collapsed aggregates. This function is the equivalent of the dimensionality() function for horizontal pivot table dimensions.

Syntax:  

secondarydimensionality ( )

 

Return data type: integer

The secondarydimensionality function always returns 0 when used outside of pivot tables.