I run a daily report that displays a list of cases and each case's status (e.g. Open, Updated, Deferred, etc.). I'm trying to use the case list to create a summary sheet that counts the number of deferred cases each day. For example, if yesterday there were 10 deferred cases, the report would show yesterday's date in column A, and 10 in column B. If today 2 of those cases were closed and no more were deferred, there would be 8 deferred cases, and I would like cell A2 to have today's date, and B2 to have 8. Is there any way to do this with a pivot table that won't erase yesterday's entry when it is updated daily? I can get it to show the 10 for yesterday, but when I update the pivot table with today's data, the 10 will change to an 8. Can I just have the pivot table add to itself another row with today's number?