Last Price Paid

[#1]

I have a list of Material numbers along with the prices that we paid for them over a full year with dates.  The prices are not always the same.  However, I am creating a Pivot table in quikview that will show me the latest price paid.  Any idea how to write that in the Expression field?

[danielrozental]

Firstsortedvalue(Price, -Date)

[MayilVahanan]

Hi

Use

FirstSortedValue(Price,-date)

Hope it helps

[rustyfishbones · Accepted solution]

The Following will work

=FIRSTSORTEDVALUE(Price,-Date)

the below will work to find out the Date where the Price is at it's highest

=DATE(FIRSTSORTEDVALUE(Date,-Price))

hope that helps

Regards

Alan