I have a line chart showing sales per week. The dimension is Week which relates to the calendar week and I want it to run from week 19 to week 18 as this is the financial reporting period for the company. There is a field called WeekID where it shows 1 for week 19, 2 for week 20 and so on to 52 for week 18. On the chart properties I have sorted the dimension Week by Expression 'WeekID' which works until I use set analysis on the sales data. The expression I have used is sum({<Week=,Month=> Sales} as I want the graph to show the full year despite the week or month selected. As soon as I put this expression in, the weeks on the graph seemed to sort in a random order.
