Question: how to calculate the difference between two dates in a pivot table?
Answer: Right-click one of the Units value cells, and click Show Values As. Click Difference From. In the Show Values As dialog box, from the Base field list, choose Date. ...  From the Base item list, choose (previous). ...  Click the OK button, and the pivot table shows the differences in weekly sales.