Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Field Settings | Excel Discussion (Misc queries) | |||
Pivot table value (field settings) | Excel Discussion (Misc queries) | |||
pivot table field settings % of... | Excel Worksheet Functions | |||
Pivot Table Field Settings | Excel Worksheet Functions | |||
Pivot Table from VBA or VB6 - Field Settings | Excel Programming |