Pivot table grouping problem

S

slscanlon3

I have a pivot table that will not group numbers in a column. ie:

Year
Group 2004 2005
10 2
10 1
11 5
11 3
12 8
12 10


Why won't these rows combine and look like:

Year
Group 2004 2005
10 1 2
11 3 5
12 10 8



All other columns group fine when I try them, but the group column does
not. Any ideas?


Sheryl
 
Top