Hi, I’m trying to convert my last report that has a pivot table to CUBEMEMBERS. I would like this so the structure and length can always be the same. Plus my formatting, fonts… will match.
But I have BRAND names that change each time the report is rerun. I don’t want to create Excel formulas to trick the system. I would rather my whole report be the same logical plan.
Below is an example of a table converted. This part will keep changing, any thoughts? (&[APEA10 – CT5458]”))
=CUBEMEMBER(“ThisWorkbookDataModel”,”[tblInvMaster].[BRAND – MODEL].&[APEA10 – CT5458]”)
Thanks