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
|