3 Replies Latest reply on Nov 21, 2018 9:55 AM by Sankar M

    How to filter the max dated records based on parameter value

    kalyan ravuri

      Hi all,


      I have some asset data, by using that i built one sheet. like as below



      Here i want to filter the data based on parameter.

      for example if i select a date range by using parameter like 01-aug-2018 to 30-sep-2018, then i want to see the asset id details with max allocated date only.

      that means if we see the data of "august" month two assets are having max date i.e 11514 and 11516 (31/08/2018),

      similarly in the month of September only one asset id with maximum date i.e 11615 (09/21/2018).


      Please help me on this, Please find the attached sample data.