Skip to Content
Jan 05, 2018 at 09:25 AM

Dynamic Local Member Formulas

159 Views Last edit Jan 05, 2018 at 03:28 PM 2 rev

I have created default report and report 001 and shared the row axis.

Reason for creating 2 report is default report has actual category and report 001 has forecast category.

I have Account in Row axis and time in col axis which has 12months

For one account alone I need to use local member formula. The formula I have used is EPMretreivedata and given the time range by selecting the column axis(time). Default report has 12 months(jan2017 to dec2017) in column and report "001" has different month(dec15). Now issue is local member formula works well in default report but it is not working properly for report 001 since the time in retrieve function is showing as jan2017(the first column in default report) and category in retrieve function is showing as actual.

Can anyone help me on this?