To create a pivot table that shows the last 7 days of data (or, more generally, the lastndays) you’re free to add ahelper columnto the source data with a formula to flag records in the last 7 days, then use the helper column to filter the data in the pivot table.
In the example shown, the current date is August 16, 2019, and the pivot table shows the seven days previous.
Fields
In the pivot table shown, there are four fields in use: Date, Location, Sales, and Filter.
Location is a Column field, Date is a Row field, Sales is a Value field, and Filter (the helper column) is a Filter field, as seen below:
Formula
The formula used in E5, copied down, is:
This formula returns TRUE when a record date is greater than or equal to today’s date - 7, and also less than today’s date.
Steps
