Hello Experts,
I am trying to make an asymmetric Report. In columns I have Time and Category what I intend to do is displayed the CATEGORY real for the month year-1 and for the CATEGORIES Propoused, Manueal and Budget.
For instance If I select the year 2017 in the context the next should be displayed.
Jan.2016 Jan.2017 Jan.2017 Jan.2017
REAL Propoused Manual Budget
Cost Center 0001 Account 1000
I was thinking about the functionallity EXCLUDE, the thing is that the user can select the year to be expanded by month. If I exclude Propused, Manual and Budget for 2016 if the user select 2016, then this Categories will be excluded, am I right?
I also tried to using a local member for the CATEGORY Real with the formula EPMRETRIEVEDATA, This should show the data stored for the selected local members. I worked Before I updated the Cost Centers and the Profit Center. The issue here is that some Cost and Profit Centers has the same Id so I get the error: "THE ID X CORRESPOND TO SEVERAL MEMBERS".
Any other idea on how can I achieve this?
Thanks for the posts
Best Regards.