How do i find the current year max month max sale order no. max sale Rate

[#1]

Dear All,

             I need to find the max sale rate for max sale order no. for the max month in during the year. i used function "last value" and "max" but im not getting the value in my straight table.

Pls find below my table:

Sldet:

LOAD com,

     unit,

     sld_fyr,

   LastValue(sld_ord_no) as sld_ord_no,

     sld_ord_srl,

     itemproduct,

     Date,

     max(sld_rate) as  sld_rate

FROM

D:\Latest_QVD_Generator\sldet.qvd

(qvd)

Group by com,

     unit,

     sld_fyr,

    sld_ord_srl,

    itemproduct,

    Date,

    MONTH,

    sld_rate  

;

Please help me to solve this above issue.

Regards,

Antony.

[er_mohit]

use aggr function in expression

it might helps you

[#3]

Hi,

     i used below condition but its not showing the max value for all items.

=max(Aggr(FirstSortedValue(sld_rate,-Date),sld_ord_no,itemproduct))