Pivot table filter based on week number

S

Stu Dapples

Active Member
Joined
Jan 12, 2009
Messages
252
Is it possible to automate the report filter on a pivot table to say, a week number, or the contents of another cell?

Long story short - Big spreadsheet covering results from inspection, I need to run week number based analysis on the results. I can do this by manually changing the pivot report filter to the relevant week. My issue is that there are 25 pivot tables in the sheet and I want to hand it over to the production guys. They will not purposely break it but I know I will be back and fourth to repair it for the rest of my natural life!!!!

Any advice appreciated....

Stu
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
Now THAT is some information!! Not tried it yet but I am certainly going to, looks like exactly what I ahve been looking for!

Many, many thanks for that, I reckon you have just released me from being the data jockey for an entire production facility!! :biggrin:
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
VBA Filter Pivot Table Question
Replies
0
Views
111
gmazza76
G
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
559
RoryA
RoryA
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
961
Alex Blakenburg
A
A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
772
adambc
A
sanantonio
  • Question
VBA, filtering pivot table based on cell value
Replies
3
Views
463
Alex Blakenburg
A

Forum statistics

Threads
1,214,567
Messages
6,120,268
Members
448,953
Latest member
Dutchie_1

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