Is there a way to make one column pull in a selected date and have another column pull is last years numbers to match in a report without having to hard code (select) the data range in the edit columns section?

Like if you select July 2023 in the filter one column will be Julys numbers only. But the other column would be July 2022?