How do i calculate Closing rate?

[#1]

Hi All,

       if i select company, year & item  in that item we should take max ord_no and corresponding that ord_no-"rate" we need to consider as "Closing Rate".

Thanks,

Ashok.

[Gysbert_Wassenaar]

You can probaly use the firstsortedvalue function. See here for a video tutorial.

[#3]

Hi,

   it's showing total and when i put in stright table item wise showing zero's.

i used like this =FirstSortedValue(sld_rate,sld_ord_no)