16 Replies Latest reply: Oct 17, 2016 1:33 PM by Sunny Talwar RSS

    Condition on Dimension

    Mohit Dahiya

      Dear All,

       

      I have a dimension Doctor.

      I am using it as a filter.

       

      Conditions:-

      1.) If i don,t select any year then need to show doctors for current year .

      2.) otherwise according to the years selections.

       

      Like

       

      Doctor     Year                         Revenue

      Sunny      2014,2015 ,2016        455667

      Manish    2014, 2015                 467787

      Arjun       2014, 2015 ,2016        454767

      Jagan      2015                           754344

      Mohit       2014                            4577



      By default 2 doctors will be present in the List box only Sunny And Arjun.

      If i selected 2015 then Manish and Sunny and Arjun, Jagan will be in List box.

      And if i selected 2014 then All except jagan.

       

       

      Regards,

      Mohit Dahiya