In the pivot table, you could manually select the items, and group them
(PivotTableGroup and Show DetailGroup)

Or, in a new column in the source data, calculate the grouping, and add
that field to the pivot table.

Chris wrote:
Hi all,

Can anyone tell me how to create groups on a field in an Excel Pivot
Table such that I can manually structure the groups themselves.

E.G.

I have a field with integer values from 1 to 30. I want to create 3
summary/grouped values for the field - 1 to 12, 13-20, and 21-30. I
then want to be able to provide summary reports on those groups rather
than each individual value in the field.

Thanks in advance for your help!

Chris Gill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html