Thanks, how using a calculation based on the date field can I get the maximum week in a dataset to get the current week numbers ? Please note it should not be based on today(). I will also need the prior week calculation based on the "date" field
Also, I understand you talking about sheet selectors to build the views and swap them.
Please help with a sample @Kelly Simon Runc
This should get you the last week (as a number) of the data
This will be applied to all rows, so easy to get the same weeks from the previous year
Unfortunately I can't open your workbook as I'm using 2018.3 what would you like a sample of?