Here’s a new one I’m trying to figure something out on. I’ve got an Inventory database. This database is updated daily, but it’s also setup for monthly snapshots. In this database, I’ve got a Status property setup. Examples of the Status property would be “Stock”, “Order As Needed”, “Do Not Reorder”, etc.
Using these monthly snapshots, I’d like to create a report that would show items whos status has changed from “Stock” last month to a different status this month.