I have fields of user, and record creation date, and count.
I applied conditional formatting to this table to highlight null values.
I now want to filter this by only month September 2020, but all the filters I apply remove the null values, since I can only filter by creation date. Is there a way I can filter to achieve the full set of results, so that for example user Alga doesn't disappear from the table when I try to keep all September dates?
I basically want to filter by current system date rather than the date used when creating the table.