You already have all the dates and rest of the tasks is just based on basic Tableau's table calculations.
Table calc is REALLY flexible, which means really complicated sometimes, but that's different discussion from "fiscal problem", but "Tableau calculation's problem".
In otehr words, normal calendar has similar problem.
Thanks for your reply and sorry for coming back so late.
Would you have any reference I can read on the "Table Caculation's problem" you are referring that will help me to solve my 445 problem?
I am a little bit lost and was not able to efficiently use the specific calendar built.
For instance, I am looking at comparing the last 4 weeks with the same last 4 weeks of last year.
In my calendar, I have the specific week numbers related to our 445 calendar, like W07, W08, W09,...
How can I compare the weeks W07 to W11 of this year vs the same week numbers of last year ?
Thanks a lot for your help,
I am not sure what is final expecting viz, but here is an example.
"Label Week Of Year" is common across fiscal year, and you can filter these weeks.
And put "Label Year" as dimension and you will get each year's sale on these 4weeks.
Wen you put quick table calc, you will get delta from last year on same label week.