The Group command is for date and number fields, and won't work if a
field contains text or blank cells.
You could manually group the items in the field, by selecting two or
more items in the pivot table, and choosing PivotTable>Group and Show
Detail>Group.
Or, add a column to the source data table, and enter a Group label
there, for each record. Add that field to the pivot table.
via135 wrote:
> hi all!
>
> in my worksheet a particular field (COL) contains "two digit
> numbers,some alphabets & some alphanumerals"..like
> (10,20,30,AA,BB,A1,B3,...).
>
> the problem is after creating a pivot table while i am trying to group
> that particular filed i am getting the msg "can't group that field".
>
> how to overcome the problem?
>
> help pl!
>
> -via135
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Bookmarks