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
|