For your filter use another LOOKUP() like this:
This formula isn't accepted as a filter condition (for some reason, the attr function isn't recognized). But can you elaborate on why it would work, please? Because if I filter the data, it seems that the lookup won't have any previous data to look at, or will it?
Now I understand what you want me to do but I still can't seem to bring an attr field close to the filter.
Here is my data. I'm stuck on "Last month vs Last year's" whereby I want to display last month's revenue and compare it to last year's (same month), then compare both values and create a KPI (growing/decreasing). Then, same thing with last month vs last 12-month average.