Pivot Table - Filter not Filtering

Warm FL

Guest

Posts: n/a

5th Feb 2010

I am on Windows 7 running Excel 2007. When using Pivot Tables, I have
experienced an intermitent problem with the Filtering of a Pivot Table. If I
drag an element up to the Filter section of the Pivot table, and then select
only 1 of the components in the element, I would expect the results to
change, but they don't. However if I drag the element back down into the
pivot, it will change.

I can send someone the file that I am using, if you would like to see it
"live".

« Solver Error | Week numbering incorrect for 2010 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter pivot table results without filtering in SQL query	Neall	Microsoft Excel Programming	1	27th Nov 2007 05:33 PM
Filter lines with Pivot table and non pivot table columns	=?Utf-8?B?R3JvdmVy?=	Microsoft Excel Charting	4	28th Sep 2007 03:16 AM
Filter lines with Pivot table and non Pivot table columns	=?Utf-8?B?R3JvdmVy?=	Microsoft Excel Misc	1	26th Sep 2007 12:48 AM
Filter lines containing pivot table and non pivot table data	=?Utf-8?B?R3JvdmVy?=	Microsoft Excel Worksheet Functions	0	24th Sep 2007 07:20 PM
Outlook 2003 Junk filter not filtering SPAM, filtering items from	=?Utf-8?B?S3lsZSBPcnI=?=	Microsoft Outlook Discussion	0	26th Apr 2006 07:13 PM