filter to show last date shipped

[#1]

I am trying to figure out an expression to show the last shipping date for each individual part in our inventory where shipdate and part# are the data fields.

[lironbaram]

hi

as i see it you do it in two functions

the easiest way

create a table with #part as dimension and max(shipdate) as expression

alternatively you can use firstsortedvalue function

it should look firstsortedvalue(shipdate,-shipdate)

[MarcoWedel · Accepted solution]

chart with dimension

part#

and expression

Date(Max(shipdate))

or to just get a listbox of last shipdates:

Aggr(Date(Max(shipdate)),part#)

hope this helps

regards

Marco

[krishna_2644]

Send some sample data.

[Anil_Babu_Samineni]

It might works

Firstsortedvalue(shipdate, -part#)

[#6]

This is exactly what I am looking for thank you very much.