I have a date field filtered on week 33 of 2018 (Aug, 13 - Aug 19th) When I use it to compare the previous two years it is showing 2017 as week 33 being Aug. 7 - 13th and not the 14th - 20th. Does anyone know how to correct this so I am comparing like weeks?
Thanks for your time
I assume you have your company's fiscal week calendar.
Fiscal calendar is 100% company unique and without that table or specific logic, no one ca answer your question.
Please attach sample data and your fiscal calendar table or logic.