9 Replies Latest reply: Mar 28, 2018 2:17 AM by Tim Müller RSS

    Horizontal Bar Chart Display Actual vs. Previous Month

    Tim Müller

      Hi Folks,

       

      I want to create a stacked horizontal bar chart to compare either (1) acutal vs. previous month sales or (2) actual vs. forecast sales.

       

      My approach is to create a ValueList with my relevant KPIs as my Dimension, e.g. =ValueList('EBIT','EBTA','TEST').


      And one meassure like this:

      if(ValueList('EBIT','EBTA','TEST')= 'EBIT',$(vEBIT),

      if(ValueList('EBIT','EBTA','TEST')= 'EBTA',$(vEBTA),

      if(ValueList('EBIT','EBTA','TEST')= 'TEST',4,NULL())))

       

      I am aware that I must create a second meassure in this bar chart to implement the comparing figures, like (1) or (2) you can see at the top of this post.

       

      But I have problems with the syntax. I like to implement the following idea:

       

      if(ValueList('EBIT','EBTA','TEST')= 'EBIT',$(vEBIT), Month(addmonths(max(Date) ,- 1)),

      if(ValueList('EBIT','EBTA','TEST')= 'EBTA',$(vEBTA), Month(addmonths(max(Date) ,- 1)),

      if(ValueList('EBIT','EBTA','TEST')= 'TEST',4,NULL())))

       

      You can see, that I want to implement the expression Month(addmonths(max(Date) ,- 1)), but I think on the wrong place and I think in the wrong way.

       

      I have problems. I am happy about your help and maybe an easier way instead of using a ValueList.

       

      Thanks,

      Regards, Tim