CUBEVALUE Function Explained
The CUBEVALUE Function in Microsoft Excel is used to retrieve a value from a cube using a set of coordinates. It takes three arguments: cube_name, x_coordinate, and y_coordinate. The cube_name argument is the name of the cube from which to retrieve the value, the x_coordinate argument is the x-axis coordinate of the value, and the y_coordinate argument is the y-axis coordinate of the value. The function returns the value at the specified coordinates in the cube.
CUBEVALUE Function Syntax
CUBEVALUE(cube_reference, field1, field2, ...)
- cube_reference: A reference to a cube field, which can be a name or a set of nested functions that return a cube field.
- field1: A cube field that is used to filter the data.
- field2: An optional cube field that is used to filter the data.
- …: Additional optional cube fields that are used to filter the data.