count based on latest date

[Zahmed14]

Hello guys , 

i need to make a count ID and by status based on  Max date 

Also how i get the status for the latest date 
Maxdate is expression i wrote :  =aggr( max(UDATED),OBJNR)  .  how to put that count in charts 

[Ksrinivasan]

hi,

below my dummy data from your table:

 whether my Table and charts were met your requirement?

if, yes, please just follow my variable, DIM and Expressions.

ksrinivasan.

[Ksrinivasan]

hi,

sry

Now i have corrected my Dummy Data,

find the Latest Status for every ID as below in table:

which is having status in fifth column that is the latest ID and Status.

and you will get it by resident table from script itself.

revert as soon.

ksrinivasan.

[Zahmed14]

I appology if i was not clear ,  the below  is  latest status for every ID here is example 

i wrote the latest status exp as follow

latest status=If(aggr(nodistinct max({<Date_New={ "<=$(v_MAX)"} >}Date_New),OBJNR) = Date_New, TXT30)

Thanks KSRINIVASAN but if you Please advise if i can make add another condition on the latest status to get a specific status like active for example how can i add this in my function