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.
Bookmarks