Hi all,
I have a problem in the presentation of the data in a combochart.
The combochart looks like this:
current year data in bars
previous year in a line
the data is grouped per week (weeknumber)
Eveyrthing looks fine, except that when I use this formula in the dimension tab
=dual(WeekStart([Date]), Week(Date))
It shows the first Monday of every week of the previous year.
I would like to see the first Monday of every week of the CURRENT year.
I've attached the (sample) application.
Best regards,
Arjan