1 Reply Latest reply: Apr 18, 2012 2:39 PM by Simon Saugier RSS

    Expressions on x-axis in bar chart

      Hi,

       

      I've tried searching the community, but couldn't find anything answering this question.  I think it's simple:  I have three expressions using set analysis for current MTD actuals, current month YTD actuals, and current month YTD forecast.  I'd like to have three such bars in a bar chart with these expressions in the x-axis, and display the bars stacked by region.  I can only get it to display in the reverse.  See the attached for this example.  Thanks in advance!!

       

      Justin

        • Re: Expressions on x-axis in bar chart

          Justin,

          One solution (not my favorite) is to create a synthetic dimension using the ValueList() function, and then in your expression use IF statements to figure out which calculation you should do.

           

          For example:

           

          Synthetic dimension:

          ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast')

           

          Expression:

          IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'MTD Actuals', <<MTD Actuals expression>>,

          IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'YTD Actuals', <<YTD Actuals expression>>,

          IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'YTD Forecast', <<YTD Forecast expression>>)))

           

          Like I said, not my favorite... but it might be your only option.