Max(Date) from two fields

[#1]

Hi All,

        I have one requirement where,there are three fields into one table viz.Item No ,Lot No. & posting date

Item No        Lot No       Posting date

A                    A1           08/08/2012

B                    B1           07/08/2012

A                    A2           04/08/2012

C                    A1           09/08/2012

so Max(Date) for A will be 08/08/2012

& Max(Date) for A1 will be 09/08/2012

when I will select A & A1 It will show Max(Date) =09/08/2012

How can I achieve this?

Thanx

[#2 · Accepted solution]

Hey,

You could try something like

rangemax(aggr(max([Posting date]),[Item No]),aggr(max([Posting date]),[Lot No]))

Hope that helps,

Frank

[#3]

Thanx frankcrezee for your timely & correct response.It helps me to achieve what I wanted.