DATE Calculations in pivot table
 

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

Thank you very much.