Sorting Weekday

[wcilliers]

Hi All,

I need some help with sorting weekday in my chart. See below the current sort. I want it to start on a Saturday and have Friday as the last day.

In my environment variables I have defined Saturday as the first day;

SET FirstWeekDay=5;

Any ideas on how I can sort this accordingly?

The field I use is my standard date field.

Weekday(CalDate) as my Dimension

Thanks,

Wynand

[vinieme12]

Under Sorting >> Sort by Expression 

=Wildmatch(WeekDay(CalDate),'Sat','Sun','Mon','Tue','Wed','Thu','Fri')