Skip to Content
0
Aug 01, 2016 at 04:43 PM

Question about asymmetric Report in Columns.

42 Views

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.