Sort Order Week - Weekday

[#1]

Hi i am having difficulty sorting the following field Week-Weekday.

i have tried Match(weekday,'MÅ,'TI','ON','TO','FR','LÖ','SÖ') without sucess.

does anyone have a solution to this?

Best

Brad

[swuehl]

Maybe sort by expression

=YourDateField

[#3]

Hi!

still no luck here potential problem is that sorting is on a pivot table dimension with CY and LY values. is it possible to point at the max year and then sort from monday-sunday?

/Brad

[sunny_talwar]

Would you be able to share a sample?

[stabben23]

Hi, You have a cyclic Group, try to sort inside this group instead.

[MarcoWedel]

Hi,

maybe one solution could be:

table1:
LOAD *,
    Dual(Week(Datum)&' '&WeekDay(Datum),Datum) as [Vecka Veckodag],
    Week(Datum) as Vecka,
    WeekDay(Datum) as Veckodag,
    Month(Datum) as Månad,
    Year(Datum) as År;
LOAD Date(MakeDate(2015)+RecNo()-1) as Datum,
    Ceil(Rand()*100) as SomeFact
AutoGenerate 365;

hope this helps

regards

Marco