I have a pivot table where I have products and then dates when we are expecting additional supply arrivals. Is there a way to filter the dates in the pivot in a way that the incomes will always start tomorrow (if I was looking at the dates today, December 15, the incomes would start with December 16, if on December 16, the incomes will start on December 17, etc.). I can see there is a range of dates but you always need a starting point and I would like that to be automatic, with no end.
It is similar to this table, just a pivot table.
MATERIAL EXPECTED_DELIV_DT
Product A 12/30/17
Product B 1/16/18
Product B 3/12/18
Product C 4/2/18
Product A 5/28/18
Product C 7/31/18
Product A 9/17/18
Is something like that possible?
Bookmarks