I want to change a specific ID tag in the following formula to an adjacent cell reference.
Here is the formula:
=CUBEMEMBER(Control!$C$2,"[Dim Site].[Sites].&[752]",D6).
I want to change the 752 to a reference to cell E6, but I can't figure out the syntax with the brackets...
Thanks,
Bookmarks