Reference cell ID in CUBEVALUE tuple instead of actual value

[ericblair]

Hi,

I'm creating a worksheet based on a cube. I'd like to reference the cell A1 instead of the cell value in my CUBEVALUE function in B2.

Here's what I have:

If I do this, I get my value:
Territory Sites
A1: UK & US |B1: =CUBEVALUE("Cube","[Measures].[Site Count]", "[Territory].[Territory Roll- Up].&[UK & US]")

But if I do this:
Territory Sites
A1: UK & US |B1: =CUBEVALUE("Cube","[Measures].[Site Count]", "[Territory].[Territory Roll- Up].&[A1]")

I get en error. And I'd like to do it this way instead.

I tried putting A1 in quotes but that didn't work. This should be possible. Does anyone see what I may be missing?

Thanks in advance!!

 

[ericblair]

Answering my own question.

It's done like this:
CUBEVALUE("Cube","[Measures].[Site Count]", "[Territory].[Territory Roll- Up].["& $A$1 & "]")