CUBEVALUE Function - Excel 2007

K

Kresimir Zoric

Is there a way to send value of other cell as a parametar for CubeValue
Function?

Example from help:

=CUBEVALUE ("Adventure Works","[Measures].[Gross
Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[FY 2004]")

I would like to use

=CUBEVALUE ("Adventure Works","[Measures].[Gross
Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[$B2]")

Where $B2 is cell with plain text value "FY 2004".

I think that problem is in "", but when i put CUBEVALUE parametar without
quotations, function doesn't work.

Thank you,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CUBE Functions in Excel 2007 1
Cubevalue (Excel 2007) versus Cubecellvalue (Excel 2003) 2
Web Excel and Excel Functions 0
Need Function for Year-to-Date spent total 3
Type mismatch in Function 5
Formula in excel to run a tally 1
cannot delete from specified tables 7
Visualising MDX with colored CM in OWC 7

Top