How to use CUBESETCOUNT Function in Excel

The CUBESETCOUNT function returns the number of items in a set.

Syntax: CUBESETCOUNT(set)

The CUBESETCOUNT function syntax has the following arguments:

• Set    Required. A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function. Set can also be the CUBESET function, or a reference to a cell that contains the CUBESET function.

Example: Let’s look at some Excel CUBESETCOUNT function examples and explore how to use the CUBESETCOUNT function as a worksheet function in Microsoft Excel:

Syntax: 

=CUBESETCOUNT(A3)

=CUBESETCOUNT(CUBESET(“Sales”,”[Product].[All Products].Children”,”Products”,1,”[Measures].[Sales Amount]”))

Note:

When the CUBESETCOUNT function evaluates, it temporarily displays a “#GETTING_DATA…” message in the cell before all of the data is retrieved.