Pivot Table using filtered data

JustinGM

New Member
Joined
Oct 30, 2005
Messages
13
Good evening Guys and Girls

I have a pivot table that uses a dynamic range as its data source.
I do not always want all of the data in the range to be pivoted so I applied a filter to the data.

The dynamic range works fine but the pivot table uses all of the data on the sheet and not just the filtered data.

What am I doing wrong?

DO I need to use an advanced filter and copy the data to be pivoted to another sheet and use a dynamic range there?

I'm sorry but I'm off to bed now (22:45 GMT) and will probably dream about this problem so any help that you can give me will
be much appreciated for my health service project oh so near to completion.

Justin
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Wish this help

I think when you filter out the data it actually just hide the row which data you dont' want to see. For the Privotable the range is still as you decide.
I dont' kwno how is your table setup but you could add more condition as filter for the privotable. I wish this help you. Or otherwise as you said copy the data you want in a new sheet and do teh dynamic range.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

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