Pivot table latest values
To build a pivot table that shows latest n values by date, you can add the date as a value field set to show maximum value, then (optionally) add a field as a row column and filter by value to show n values. In the example shown, Date is a value field set to Max, and Sales is a Row field filtered by value to show top 1 items.
Pivot Table Fields
In the pivot table shown, there are three fields, Name, Date, and Sales. Name is a Row field, Sales is a Row field filtered by value, and Date is a Value field set to Max.
The Date field settings are set as shown in below. Note the field has been renamed to "Latest" and set to Max:
The Sales field has a Value filter applied to show the top 1 item by Latest (Date):