7 Replies Latest reply on Sep 25, 2018 4:24 AM by Jim Dehner

    Filter previous Day

    Bryan Fernandez

      Hi Guys,


      These (2) sheets have the same data source. But what I want to make is when I pick a 'day' using the filter (encircled with red), The

      sheet (1) shows the data from the current date that I pick, and on the sheet (2) i want to have the values from the previous day.

      like this example I pick Day 18. Sheet (1) should have the data of Day 18 but Sheet (2) must have the data of Day (17) ,but now they have the same values.

      Is it possible?