Show last 7 days in Pivot Table

[nashar]

Is there a way to dynamically have a pivot table show the last seven days of data? I know I can choose either show this week, or last week, but I need them both. If I could have it show both this week and last week in the same table or have it show the last x number of days, either would work. The data is being pulled from an Access database.

 

[rconverse]

You could add the date to the values section of the pivot table as average, min, or max. Then you could filter the rows using the Top 10 option. Choose top 7 by average, min, or max of date and it will only display the last seven dates in your file.

HTH,
Roger

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Dynamic Date, Value Filters,
implemented with code.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_02_10.xlsm
Pdf preview:
http://www.mediafire.com/file/gwmdid5jwnh/05_02_10.pdf

 

[sorted]

Excel 2007 PivotTable
Dynamic Date, Value Filters,
implemented with code.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_02_10.xlsm
Pdf preview:
http://www.mediafire.com/file/gwmdid5jwnh/05_02_10.pdf

Im sure this is too late for your instance, but if anyone else is looking for a solution.

If its possible to add a column to your source data and call it "7 day inclusive', 'qualifyer' or something.

Assuming column A is a date column, add this formula to your qualifier column and drag it down for all of your rows:

=IF(A2>=(NOW()-7),"y","n")

Then simply filter your pivot table on the qualifier.