DATE Calculations in pivot table

A

applesandpears

1.How would I add new data to the original source and automaticall
update the pivot table?
2. If the order has gone past the agreed date how do I show that i
pivot tables? If the days in between the start date and end date is mor
than 15 days? And if I have an agreed date(SET DATE) and to show order
ended before and after(SET DATE).

Thank you very much
 
Top