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:
The secondarydimensionality function always returns 0 when used outside of pivot tables.