1 Reply Latest reply on Nov 24, 2018 9:15 AM by Norbert Maijoor

    YTD filter ,Start and End Date Filter

    swathi p

      Hi All,

      I have a scenario in which I have a drop down in which I have to select YTD,MTD,3 years YTD etc.and I have  a filter with start and End Date.

       

      When ever I select YTD..Start and End Date Filters should change

      if I select MTD,it should reflect in Start and End Date

       

       

      Could someone help with this case.

       

      Thanks,

      Swathi

        • 1. Re: YTD filter ,Start and End Date Filter
          Norbert Maijoor

          Hi Swathi,

           

          Not sur but just as an starter find my approach as reference below and stored in attached workbook version 10.2 located in the original thread.

           

           

          1. M1. YTD: if year([Date])=year(today()) and [Date]<=today() then [Value] END

           

          2. M2. MTD: if month([Date])=month(today()) and year([Date])=year([Date]) and [Date]<=today() then [Value] END

           

          3. P1. P1 YTD, MTD

           

          parameter2.png

           

          3. M3. YTD or MTD: if [YTD, MTD]='YTD' then [M1. YTD]  elseif [YTD, MTD]='MTD' then [M2. MTD] end

           

          Hope it helps,

           

          Regards,

          Norbert