Report Filter - Can you filter one column against another or a summary field
In the report filter, can you compare the value in one column against a summary field or another column? For example, I am building a report that needs to pull data from a sheet for rows that were created in the previous month. This report will be going into a dashboard and will need to be updated every month. At this time, I just have the date comparing against a value for last month.
It cannot be a rolling - last 30 days. It has to be for an entire month.