Show last 7 days in Pivot Table

N

nashar

New Member
Joined
Nov 16, 2006
Messages
20
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
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
 
Upvote 0
Herbert Seidenberg said:
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
Click to expand...


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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Comparing Grouped Pivot Table Data
Replies
1
Views
105
cwhaley1
C
B
  • Question Question
Filtering Pivot Table - use relative position in list?
Replies
1
Views
262
johnny51981
J
M
  • Question Question
Help to SUMIF past 12 months
Replies
3
Views
170
RoryA
RoryA
B
  • Question Question
Removed Feature: Pivot Table
Replies
0
Views
206
bec98
B
SandsB
  • Question Question
Pivot Table showing just averages
Replies
4
Views
155
SandsB
SandsB

Forum statistics

Threads
1,224,876
Messages
6,181,519
Members
453,050
Latest member
Obil

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top