2 Replies Latest reply on Jan 30, 2019 10:27 AM by Randy Demaree

    Filter Date to show all data for things still happening

    Randy Demaree

           I tried to abstract this into a relevant example using the Superstore model.  So I am trying to filter to things that happened yesterday, but keep all the data that happened prior to that.  So in the superstore example I want to see all of the customers transactions but only if they bought something on a specific date.  So I set the date I wanted to see to 3/20/2016 and I get a nice list of those who purchased something that day:

      But my hope is to get all of these customers purchases like so (Cheating making a filter based off the customers themselves instead of the date):

      Attached is the Superstore set up of these two sheets on the end. 

      Any insight on how you would go about solving this would be appreciated.

       

      Thanks