View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Pivot table: Most recent price for an item?

Have lots of sales data, and would like to have a column display the
most recent price for an item.
Source data includes many shipments for various items, along with cost
and burden figures.

How might I populate within the pivot table, a column which gives the
most recent price for the item in that row?

TIA for thoughts.
pierre