Max with Aggr

[vipingarg23]

Hi Team,

I have below data:

A	B	Date
1	111	01-01-1996
1	111	01-01-1997
1	111	01-01-1998

!

I want output ( maximum of the date) in straight chart as below:

A	B	Date
1	111	01-01-1998

Means, I want max of date for single value of A,B. Can anyone help me out?

[prma7799]

try this

Aggr(Max(Date),B)

or

Aggr(Max(Date),A,B)

[vipingarg23]

No..Not working. It is giving me max among all values. Not according to Column A,B

[karthikoffi27se]

Hi Vipin

try Date(max(Date))

Many Thanks

Karthik    

[vipingarg23]

It is also not working Karthik.

[prma7799 · Accepted solution]

PFA...

[vipingarg23]

Thanks a lot P M

It is working fine. I was doing silly mistake.

Thanks once again for your help.

[pradosh_thakur]

Check this  out