I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent: Creating a set of members of some sort, like products or customers using the CUBESET function Extracting the members from the set one by one using the CUBERANKEDMEMBER function Using CUBEMEMBER to define which measures I wanted to show from the cube/data model Adding some slicers on other properties like product color, year, month, etc. Calculating the values of some measures for each extracted member using CUBEVALUE and referring to the cell containing the measures and to the slicer as an argument to the CUBEVALUE function The CUBESET functions have two optional parameters that allow the set to be ordered. Usually, we order the members in the set on descending order of a measure or a tuple which is a combination of a measure and members from

I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent: Creating a set of members of some sort, like products or customers using the CUBESET function Extracting the members from the set one by one using the CUBERANKEDMEMBER function Using CUBEMEMBER to define which measures I wanted to show from the cube/data model Adding some slicers on other properties like product color, year, month, etc. Calculating the values of some measures for each extracted member using CUBEVALUE and referring to the cell containing the measures and to the slicer as an argument to the CUBEVALUE function The CUBESET functions have two optional parameters that allow the set to be ordered. Usually, we order the members in the set on descending order of a measure or a tuple which is a combination of a measure and members from

Аналитические функции в Excel (функции кубов): КУБЗНАЧЕНИЕ, КУБЭЛЕМЕНТ, КУБМНОЖ, КУБПОРЭЛЕМЕНТ, КУБСВОЙСТВОЭЛЕМЕНТА, КУБЧИСЛОЭЛМНОЖ, КУБЭЛЕМЕНТКИП.