DE.TOPCOUNT

Returns the number of top-level elements of a specified dimension. That is, elements with no parents.

Syntax

DE.TOPCOUNT(Database alias,Dimension)

Dimension is the name of the dimension whose top-level count you want to retrieve.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.