COUNTROWS this week vs last week with specific key
Hello everyone! I have those 5 tables linked: A simple calendar table (Week, month etc is not shown here but they exists) An attribute list: Attribute per article A sales master: 1 unique row for each Order A booking table: All bookings per order (several rows per order) An archive that shows me the open orders per week. What I would like now to calculate is this: The number of orders in the archive table that does not exist in this week compared to last week > Lost orders The number of orders in this week, that are listed in the table archive and have a booking = "XX" in the table bookings. How would you do that?
