Data filter

[subbareddykm]

Hi All,

I have one requirement,i tried a lot but i m not able to get that.

For example :

i have fields like  ID, Type, Date and Time.

What i want is

For every ID , If Type=A and Max(Date) and Max(Time)

Note :

     1. If ID is having no of dates select max date and pick max time .

     2. If ID is having Same date and diff time pick accoding max time

     3. Only for Type = A

[subbareddykm]

Can any one help me on this    ?

[settu_periasamy]

subbareddykm wrote:

i have fields like  ID, Type, Date and Time.

In your attachment there is no Date and Time Field. Can you Post your output also?

[manojkulkarni]

what is your expected output ?