Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table: Most recent price for an item?
I can tell you a formula that can return the last value entered in a row or
column. Will that work for you? "Pierre" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table: Most recent price for an item?
On Jan 3, 2:24*pm, "Gaurav" wrote:
I can tell you a formula that can return the last value entered in a row or column. Will that work for you? Gauray, I'll have a go at it. (I was hoping for something within the PT that would draw in the most recent date, as that would preclude the reconstruction of the table if fields are added or changed at a later time.) Thanks. Pierre |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table: Most recent price for an item?
On Jan 3, 2:37*pm, Pierre wrote:
On Jan 3, 2:24*pm, "Gaurav" wrote: I can tell you a formula that can return the last value entered in a row or column. Will that work for you? Gauray, I'll have a go at it. (I was hoping for something within the PT that would draw in the most recent date, as that would preclude the reconstruction of the table if fields are added or changed at a later time.) Thanks. Pierre Found a way. In my source data, I sorted by shipped date, did a lookup for that item in the price column and that found the most recent price. I extended the range for the PT, added the column containing the latest cost. Thanks to all who pondered. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Pivot Table to only 1 Item | Excel Discussion (Misc queries) | |||
Most recent price per item | Excel Worksheet Functions | |||
Pivot table - total sell price | Excel Discussion (Misc queries) | |||
Have a Pivot Table Include a "% of an item" | Excel Worksheet Functions | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) |