4 Replies Latest reply on Dec 25, 2018 10:54 PM by kavi ram

    Display the records where the dimension flied flag('Y') is available since more then 5 months continuously

    kavi ram

      Hi Team,

      I would like to display the output for the following point.

      1) Display the records, if dimension field "Watch list Flag"  value as "Y" data available since more than 5(>=) months continuously from the month selected.

       

      The data looks below, the final answer should be only one record 'Client 4' where this record having continues 'Y' for 5 months if Month selector is Nov2018.

      I have attached the workbook also for reference.

      Thanks in advance.

      Regards,

      Kavi