Excel 07 - OLAP cube
I am looking to pull cube values from a partial member description.
current formula:
I want to change the![]()
=CUBEVALUE("CSGDSS","[Measures].[Regular Cases - Inventory On Hand]","[Products].[Product ID].["&$F4&" - "&$G4&"]")
portion to be wildcard only so i pick up the cell reference in column F, and then any other text in the description.![]()
" - "&$G4
Is this possible in cubevalue?
thanks for any help.
Bookmarks