Looks like you forgot to attach your workbook.
Hi Norbert, thank you very much for taking a look and coming back with some advice.
I was actually looking for it to show only the week's data, or the month, or the year. I can see the solution you have kindly given gives the full year data, but at different levels of date granularity (week, month, or year).
And I can see the solution is to use 3 x sheets, and then combine on the dashboard using a filter. I actually have a couple of dashboards built in the real solution, with multiple sheets, so perhaps doing the 3 x sheets method may ramp up the number of sheets required?
Many thanks again for taking a look!
Thanks for prompt reply. Appreciated!:) Would you like to see "Latest week" , "Latest month", Latest year"?
Yes that's right, latest week, latest/current year etc. And preference is running on one sheet only.
Actually, the Week Number coming in from the database is only 1-52, no year field as such (it's all 2018 data).