Compare current month with previous year


#1

Hi there,
I’ve got an orders table with 4 years of orders. We’d like a block or way to see which client’s ordered this month and along side that see which client’s ordered the same month last year. For example: Show orders Nov 2018 and show orders Nov 2017. I couldn’t see a way to create a view that would automatically show the previous year’s month. Any ideas welcomed!
Thanks!


#2

What about adding two Formula fields with YEAR() and MONTH() and then grouping by month and year?