Pivot table grouping
I'm trying to group columns in a pivot table according to
4-4.49
4.50 - 4.99
5.0 - 5.49
5.50 - 6
In the grouping box I enter 4 as my start at and 6 as my end, with .49 as
the By. Doing so causes the following column heads to appear:
4-4.49
4.49-4.98
4.98-5.47
5.47-5.96
I'm sure it's something obvious that I'm missing. Any ideas?
Much appreciated,
Susan
|