Hi Nicolas could you please attach sample date to help you further
I have attached a sample workbook for this:
The data is filtered by my Date filter which keeps the past 6 full weeks relative to today and today last year
I have sorted WEEK(Datefield) by the Datefield and AGG(Maximum)
The data is colored by YEAR(Datefield)
Ohh, and remember to replace Datefield with your own date field
I hope this helps!
Superstore_test.twbx 316.8 KB
you're my HERO !!! thanks you very much ! i was close but i've missed "dateadd" in a "dateadd" etc.
it works perfectly !! thanks you again :-D