Pivot Table Field Settings
 

Is there a way to select the "Last" value using a pivot table?

I have a spreadsheet with dated sales data. This data is sorted by date.
When displaying the data in a spreadsheet I would have the following columns:

item, item_description, price, qty_sold, sale_amt

The qty_sold and sale_amt are sums.

I would like the price to be the last price found in the "datasheet".

Is this possible.

Thanks in advance.