Report Filter - Can you filter one column against another or a summary field

Matt Galindo

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.

Thanks.

Leibel S

@Matt Galindo

You would need to do that in the sheet (make a column that check if it has the correct criteria) and then use that column as your filter in the report

Leibel S

@Matt Galindo

You would need to do that in the sheet (make a column that check if it has the correct criteria) and then use that column as your filter in the report

Matt Galindo

Got it.

Thanks!