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.
Thank you very much, IT works perfectly. but there is one problem too. This is my Table
And I got the right:
But the problem is I want to make a KPI and want to make some operations with that number "62.61" (The sum of all the price of all the Part_id of that vendor) I want it to multiply Quantity(Qty) with that 62.61 and show it in a KPI.