Does anyone know whether I can apply a filter to compare YTD, QTD or MTD that updates daily/is live?
E.g needing to compare January & first few days of February.
I have used the week filter at the moment: is between 0 and 7.
It does the job but it doesn't refresh every week that closes so I have to change it manually each time.
Thank you :)