Posted 21 March 2023, 9:55 am EST
Hello,
I’ve got the following cell formula :
MEMBER(“PyramidDemo”,“[Manufacturer].[Manufacturer].[”&A2&“]”)
pay attention we concatenate cell A2 to the formula ,
the question is there a way to use SpreadJS engine to get the final formula,
so for example if A2 value is “Acme” I expect to get after formula evaluation :
MEMBER(“PyramidDemo”,“[Manufacturer].[Manufacturer].[Acme]”).
Thanks.