keep in mind javascript is needed for full functionality of the web portal.
Welcome back to our frequent blog of Excel functions from A to Z. Today we look at the CUBESETCOUNT function.
La función CUBESETCOUNT
When the workbook is connected to a Microsoft SQL Server 2005 Analysis Services o una Data SourceA "Data Source" refers to any place or medium where information can be obtained. These sources can be both primary and, such as surveys and experiments, as secondary, as databases, academic articles or statistical reports. The right choice of a data source is crucial to ensure the validity and reliability of information in research and analysis.... posterior, esta función devuelve el número de ítems de un conjunto.
The CUBESETCOUNT The function uses the following syntax to operate:
The CUBESETCOUNT The function has the following arguments:
- to place: esto es obligatorio y representa una cadena de texto de una expresión de Microsoft Excel que se evalúa como un conjunto definido por el CUBESET function
- to place además puede ser el CUBESET function, o una referencia a una celda que contiene el CUBESET function.
It should be noted at the same time that:
- the CUBESETCOUNT The function is supported only when the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or a later data source.
- when the CUBESETCOUNT The function evaluates, temporarily display a message “# GETTING_DATA …” in cell before all data is retrieved.
Please, see my examples below:
= CUBESETCOUNT (CUBESET (“Sales”, “[Product].[All Products].Niños “,” Products “, 1,”[Measures].[Sales Amount]”))
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.
Sign up to receive our newsletter