Custom sort doesn't work

[#1]

Hello everyone!

I have 4 fields Working Center, Order, Order Start Date and Order End Date.

I want to sort my straight table in this order: Working Center A-Z, Order by min(StartDate).

I created custom sort expression , but it doesn't work.

See attachment

What have I done wrong?

[#2]

I want to arrange orders on working centers according to their min startdate on this working center.

Is it clear?

[swuehl]

The sort by expression for second dimension will not be evaluated using the context of your first dimension.

What about using the expression labelled 'Min' ( =Min(StartDate) ) as second sort priority as shown above, then hide the expression column in presentation tab?

[#4]

my final goal is to create Gant chart (see attachment).

And because of incorrect sorting some orders dissapear....

may be you have some better idea to make Gant?

[swuehl]

You may consider calculating some values like duration in the script.

I played a little with calculated dimensions, maybe this gives you some ideas:

[swuehl]

This thread discusses a different approach with some script work

MS Project style Team Planner view

[#7]

I solved the problem. Instead of Order must be used Order & autonumber(StartDate&'_'&EndDate) field.And sorting works