Skip to Content
Oct 23, 2019 at 03:35 PM

EPMDimensionOverride with Excel Formulas?

72 Views Last edit Oct 23, 2019 at 02:53 PM 5 rev


I'm trying to create a report where the Column Axis Dimension TIME will have three members that change depending on the current month selected on a separate worksheet.

I don't know how to use the EPMDimensionOverrideFormula to get the third parameter to reference three cells on the other worksheet, cells E5 (Current month), F5 (Prior Month), G5 (Prior Year).

I can get the above formula to work no problem if I specify the third parameter as one of the cell references =EPMDimensionOverride("000","TIME",Selections!E5) but not with all three months cell references together?