Hello,
Basically, I'm trying to have a date filter. The goal of this filter to check three columns, and if one of the columns match the filtered date, it should show the entire row with the data.
I have the following table:
| ID | Quota | Quota Date | Revenue | Revenue Date | Future Revenue | Future Revenue Date |
| 1001 | $100 | 2022-12-01 | $200 | 2022-10-01 | $500 | 2022-11-25 |
| 1001 | $100 | 2022-12-01 | $50 | 2022-12-01 | $400 | 2022-12-01 |
| 1003 | $300 | 2022-09-01 | $100 | 2022-11-01 | $300 | 2022-12-13 |
| 1004 | $400 | 2022-10-01 | $200 | 2022-09-01 | $200 | 2022-11-30 |
| 1005 | $500 | 2022-11-01 | $100 | 2022-10-12 | $100 | 2023-01-01 |
| 1006 | $200 | 2023-01-01 | $500 | 2022-08-01 | $50 | 2022-12-04 |
Basically, if I choose October in the filter, I would like all rows where the month of October is exists in one of the columns. Ideally, the filtered data should look like this when I filter for October:
| ID | Quota | Quota Date | Revenue | Revenue Date | Future Revenue | Future Revenue Date |
| 1001 | $100 | 2022-12-01 | $200 | 2022-10-01 | $500 | 2022-11-25 |
| 1004 | $400 | 2022-10-01 | $200 | 2022-09-01 | $200 | 2022-11-30 |
| 1005 | $500 | 2022-11-01 | $100 | 2022-10-12 | $100 | 2023-01-01 |
| Total | $1000 | | $500 | | $800 | |
This should show any activity done or to be done in the filtered month. Is this possible?
