Sortorder (weekday+date) in pivottable

[bartvanwetten]

Hi all,

In attached qvw is a pivottable with a dimension 'WeekDay+Date' horizontal. But somehow i cannot get the order right.

Can anybody help me out on this one?

Thank you in advance!

[sunny_talwar · Accepted solution]

May be this sort order in the cycle group itself

=RangeSum((Dim * 1E10), Date#(SubField(WeekDayName, ' ', -1), 'D-M-YYYY'))

[bartvanwetten]

And again works fine!