# How to Use Excel's CUBEVALUE Function

Save

Excel's CUBEVALUE function returns an aggregate value based on the specified member expressions and might typically be used to calculate a sales total from a given year. This function requires a data source. The following steps will show how to use Excel's CUBEVALUE function.

• Learn the syntax for CUBEVALUE. It's CUBEVALUE(connection_name,member_expression_1[,member_expression_2]...
[,member_expression_n)
where connection_name is the name of the connection to the data source and a member_expression is an expression that defines a set of members in the cube. A member_expression may be defined by the CUBESET function.

• Expect CUBEVALUE to display the text "#GETTING_DATA..." in the cell while the data is being retrieved from the data source. CUBEVALUE will return the #NAME? error value if connection_name is not a valid connection or is unavailable.

• Interpret the most likely cause of a #VALUE error value to be caused by an invalid member of the defined set.

• Examine possible causes of a #N/A error value. This can be the result of incorrect syntax in a member_expression, a member_expression that references a non-existent member, an empty return set or a return set that has a member with a different dimension from the other members. A #N/A error value can also occur when CUBEVALUE references a session based object that is no longer available.

• Look at some examples of CUBEVALUE. =CUBEVALUE("Sales","[Measures].[Profit]","[Time].
[2004]","[AllProduct].[Beverages]")
will select records for the profits on beverages for 2004 from the Sales cube.
=CUBEVALUE("Sales",\$A\$1,\$B\$2,\$C\$3) will return the member set formed by the intersection of the expressions contained by the cells A1, B2 and C3.

## Related Searches

Promoted By Zergnet

## Resources

### You May Also Like

• How to Do a Cube Root in Excel

The cubic root is the mathematical operation that is reverse raising a number to the power of 3. For example, the cubic...

• How to Use Excel's YEAR Function

Excel's YEAR function returns the year of a given date. The returned year will be an integer between 1900 and 9999 inclusive....

• How to Use Excel's Choose Function

Excel's Choose function returns a value from a list of arguments based on the specified index number. For example, this might be...

• How to Use Excel's Combin Function

Excel's Combin function returns the number of ways that the specified number of items can be combined. It may be used to...

• How to Use Excel's CUBEMEMBER Function

Excel's CUBEMEMBER function returns a unique member from a cube that matches the specified expression. It is used primarily to determine the...

• How to Use Excel's GETPIVOTDATA Function

A pivot table is a useful tool that can sort and total information contained in cells. To use Microsoft Excel's GETPIVOTDATA function,...

• Excel Cube Functions

The industry term "cube" refers to a method of analyzing the contents of a database for purposes of learning more about your...

## Related Searches

Check It Out

### Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.