1 of 1 people found this helpful
Hello Kerry Evert I would create a calculated field that will rank the items by sales for the most recent day. You can then filter on that calculated field. You could also try to filter by top 7 by sales. If you include a workbook I could be of more assistance. Did this help? Let me know by clicking.
Thanks. I'm afraid I can't share the workbook as it is sensitive information, and isn't actually sales, but was using that as a generic way of explaining.
This solution, although I can see that it could work, isn't going to do the trick for my data.