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,
 
Top