When I filter date field I want all the records to that Organization should show (not just single record to selected value in filter) with its all past records.

Hi Folks,

I have this dummy data set about the organizations making changes in their status and as they make changes we record it in our data set, I have 2 filters organization name and change date.

I want to achieve when I select any month-year from date filter then from that selected month-year value all the previous record to organizations should appear.

e.g. Org E has made many changes since Aug-23 till Feb-24.

if I select Feb-24 then its all previous records should appear in the view and not just single record for Feb-24, similarly if I select Dec-23 then its records from Aug-23 to Dec-23 should appear.

I am stuck at this point.

I appreciate your help.

I have attached the workbook, kindly look into this.

Thanks,