Sort nodes by cck dynamic_field?

yes this is exact the problem.

it would just kill your site performance you have to load every node, and calc all fields

dereine: thank you thank you thankyou for the fantastic work you're doing! When you answer a support request, can you either mark it 'fixed' or 'postponed (maintainer needs more info)' depending upon which you do? The vast majority of the time one or the other will be correct, and the submitter can change it back if they need further help.

(For example, this one is fixed =)

And on to the issue: Because the data is not in the database, Views cannot sort by it. Views does not support a solution of loading all records and then sorting.

no problem i like fixing issues, but i'm not sure what status i have to use

There are two solutions, depending on whether you want the result stored in the database or not.

1) Use computed field and choose the option to store the data in the database, Then you can do regular views on it.

2) Use Views Calc, which lets you create a field that will do dynamic totals using SQL, not PHP (you have to know enough about SQL to know how to define your value that way). This will work in Views.

If you think you've answered it, use fixed. If you were unable to answer it due to not enough information, that one's obvious. If you're not sure if yo'uve answered it but you've tried, use fixed and let the submitter know they can re-open it. If you couldn't really answer it at all and want somneone else's expertise, leave it active.