9 Replies Latest reply: Apr 14, 2014 3:58 AM by Tresesco B RSS

    Need to change Expression dynamically based on a value in the dimension(not selection)

      Hi Everyone,

       

      I actually have a very basic issue. I have a chart in which I am using 2 fields i.e Time (Monthly,YTD) and KPI (Sales, Target), coming from isolated Inline Tables as dimensions for labeling purpose only. As shown in the table below. Based on the Values of these fields, I need to changes the Expression Label.

       

      MonthlyMonthlyMonthlyMonthlyYTDYTDYTDYTD
      SalesSalesTargetTargetSalesSalesTargetTarget
      2012122013122012122013122012201320122013
      4545

      5656

      5666767666767676676

       

      So, I am keeping only one expression and using 'If else' statement, putting 4 logic inside it. However I am not able to achieve the same thing for Labels.

      If you see the above table for YTD, labels are only years i.e. 2012 & 2013.

      Would appreciate the help and suggestions.

       

      Thanks,

      Neelam