Sheet Summary Report by Month
Hi everyone, I've created a report that we generate every month by choosing to run the report between X and Y date. Simple enough. The report is generated from our master sheet.
I have another sheet that calculates some statistics. I.e, number of staff, cost per trip, cost per trip type, etc.
Our mastersheet can be filtered out by date from our report because we ask for the start and end date on the online form, however, how can I include my statistics page within my report? I know it will appear underneath my mastersheet report but it won't filter by the "when" in the report options. This is crucial as we must know the costs, number of trips per date.
Any guidance is appreciated, I feel this is more of an architectural challenge then formula.