Want to find the price of latest date or recent date

[RishabhTFC]

Hello Guys,

I want to make a bar graph that shows the price of vendors on the latest date.

this is the given sample to try. I tried firstsortedvalue function but it only shows valut of only V1 all others vendors are showing "-".

Please help me to solve this issue. 

Vendor_id	Date	Price
V1	20140601	155
V1	20151001	158.56
V1	20180101	93
V2	20100501	171.43
V3	20110718	121
V2	20170501	55
V1	20110718	118

[vishsaggi]

Did you try Ruben's expr?

Ma be try his expr like below:

= Sum(Aggr(FirstSortedValue(Price, -Date), V_id, Part_id)*Qty))