LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Pivot Table Filter Error

When I filter data in my pivot table in Excel 2007, it is splitting up the
same data. For instance, if there are numbers describing a job poisition the
filter is splitting the people who are in group 12. instead of showing me 25
people in group 12 it is showing two groups of 12's and splitting them up as
23 and 2, instead of one group of 25.

I formatted the column as all numbers and that didn't work.

Any other suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table - Filter - no filter by value Andrew in Jax Excel Discussion (Misc queries) 0 September 18th 09 02:38 PM
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 03:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
Filter lines containing pivot table and non pivot table data Grover Excel Worksheet Functions 0 September 24th 07 07:20 PM
Pivot Table Filter Lisa Excel Discussion (Misc queries) 4 September 6th 06 09:11 AM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"