I'm trying to find the sum of sales and average sales for the latest week, previous week and previous but one week to be based on the Maximum Date according to the user's selections.
So if a user picks 1 Jan 2021 the weeks will be different to those shown if the user picks 27 Sep 2022.
I've seen similar posts based on max_date or Today's date but these don't show what I need because users can filter by date and want to see the latest/previous weeks for their selection, not the whole dataset. In my real workbook, users can filter by date and also 7 other filters (if that's important). Also, if it helps, I've a column called "w/c" that contains the date of the relevant Monday of every date (so there are 7 days assigned to each "w/c" value).
Thanks in advance for your kind help. I've struggled with this for a few hours and am admitting defeat!
see the red tab - your example has an error - Sept 15 is not a Sunday
it may be why you are having issues
Glad to help out and if this solves your problem please mark the response Best to make it easier for others to find and to close the thread
Thanks
Jim
