I have a sheet in which data is updated as entered by various users. The table contains values associated with dates. I want to generate a report that will contain all the values and data for all dates from the previous month. Let’s say if I want the report for February 2020, I create a virtual column with format month([Date])&year([Date]) that returns 22020, and use that as a condition for my report ( [virtual column]=(month(today())-1)&year(today()). But the report manual says that conditions determine whether or not the report would be generated at all.
How do I achieve this?