Order by in "FOR" clause

[cognosda]

I want to replicate the logic of Oracle analytical functions in Cognos FM 10.2.2. I was able to figure out that I can use the "FOR" function to do the "partition by" piece. Now how do I implement "order by" part of it in that expression?

Example oracle function: min(date) over (partition by field1, field2 order by field 3 asc)
Cognos version of oracle function:  min(date for field1,field2)

How should I implement the bolded "Order by field3" in Cognos FM?

Thanks for your help.