max values

[Guest]

hi there.... i need help with the following.

I need find the max value of the top 60% of entries filtered in acsending
order.

 

[Guest]

I need find the max value of the top 60% of entries
The max value will the same no matter what percent is selected.
Filtering has nothing to do with order.

Or do you mean that you want to sort ascending, extract 60%, then take the
last record which will be the maximum of that record set?

 

[Guest]

yes, thats what i mean.... i have a table with a field named ActualAht, this
is input by date and agentID. i have to sort the data in ascending order,
then filter 60% of those records and find the Max value as this would set a
target for the following month.