Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Did you try Ruben's expr?
Ma be try his expr like below:
= Sum(Aggr(FirstSortedValue(Price, -Date), V_id, Part_id)*Qty))