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?