View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135
 
Posts: n/a
Default grouping field in pivot table!


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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=509705