I have a chart that displays weeks along the X-axis. I need to have the date sorting go from July-June and it was displaying properly until Jan 1. Since then, January weeks are displaying at the beginning of the X-axis. How do I get them to display at the right end of the X-axis (after December)?
The field being used for the chart is
Date(WeekOfYear(Respondents::date); 1 ; Year(Respondents::date))
the X-axis is
Respondents::week start & " - " & Respondents::week end
Chart sort order is by cWeek (ascending)