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?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |