Dynamic filtering with different parameters

Question

Hey everyone.

I am trying to dynamically filter a date based on some previous formulas validation. Here's a visual example:

The user has to input this data (which represents Dates) every day, which is dauting. So the idea is to replace it dynamically.

I created a formula that checks the date and get the previous date, which is the one that should be inputted in the filter.

As you can see, the column "Date -1" Should always replace the content within the filter. How to make it automatic?

thanks!

DataNath · Accepted Answer

Unless I'm reading/understanding this wrong, couldn't you just use:

[Data] = [Date -1]

As your last line? Instead of the manually typed date.

Joker_Hazard · Accepted Answer

Yeah, I've had the exact same thought as you afterwards. It did work.

I was thinking of a way complicated model, like using analytical apps or Macros.