8 Replies Latest reply: May 4, 2016 1:26 PM by Phaneendra Kunche RSS

    conditional dimension in line chart

    scotly victor

      Hi all ,

      I have conditional dimension in line chart.

       

      If(DateTemp1 = 'YTD',FiscalMonth,

      if(DateTemp1 = 'QTD',FiscalMonth,

      IF(DateTemp1='MTD',[Day (#)],

      IF(DateTemp1='WTD',[Day (#)]))))

       

      I have list box with YTD,QTD,MTD,WTD .

       

      When I select YTD ,QTD    no issue, Fiscal Month displays.

       

      When I select MTD,WTD Output would be like this

      fiscal month.png

      can anyone help?