software

hi all!

in my worksheet a particular field (COL) contains quot;two digit
numbers,some alphabets amp; some alphanumeralsquot;..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 quot;can't group that fieldquot;.

how to overcome the problem?

help pl!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=509705The 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 PivotTablegt;Group and Show
Detailgt;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:
gt; hi all!
gt;
gt; in my worksheet a particular field (COL) contains quot;two digit
gt; numbers,some alphabets amp; some alphanumeralsquot;..like
gt; (10,20,30,AA,BB,A1,B3,...).
gt;
gt; the problem is after creating a pivot table while i am trying to group
gt; that particular filed i am getting the msg quot;can't group that fieldquot;.
gt;
gt; how to overcome the problem?
gt;
gt; help pl!
gt;
gt; -via135
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
hi ..Debra!

your second idea is ok!

but i can't understand the first one ie. manual grouping!

the pivot table has page filed called quot;memoquot; in which
10,20,30,15,12,aa,ab,ba..are the contents!

you are giving suggestion to manually group the contents 10,20,30,15
amp;12 am i correct?

pl explain me in detail which would be helpful for me!

thks!

-via135Debra Dalgleish Wrote:
gt; The Group command is for date and number fields, and won't work if a
gt; field contains text or blank cells.
gt;
gt; You could manually group the items in the field, by selecting two or
gt; more items in the pivot table, and choosing PivotTablegt;Group and Show
gt; Detailgt;Group.
gt;
gt; Or, add a column to the source data table, and enter a Group label
gt; there, for each record. Add that field to the pivot table.
gt;
gt; via135 wrote:
gt; gt; hi all!
gt; gt;
gt; gt; in my worksheet a particular field (COL) contains quot;two digit
gt; gt; numbers,some alphabets amp; some alphanumeralsquot;..like
gt; gt; (10,20,30,AA,BB,A1,B3,...).
gt; gt;
gt; gt; the problem is after creating a pivot table while i am trying to
gt; group
gt; gt; that particular filed i am getting the msg quot;can't group that fieldquot;.
gt; gt;
gt; gt; how to overcome the problem?
gt; gt;
gt; gt; help pl!
gt; gt;
gt; gt; -via135
gt; gt;
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=509705To manually group items:

In the pivot table, click on an item, to select it
Hold the Ctrl key, and click on the remaining items you want in the group
On the pivot table menu bar, choose PivotTablegt;Group and Show Detailgt;Group

via135 wrote:
gt; hi ..Debra!
gt;
gt; your second idea is ok!
gt;
gt; but i can't understand the first one ie. manual grouping!
gt;
gt; the pivot table has page filed called quot;memoquot; in which
gt; 10,20,30,15,12,aa,ab,ba..are the contents!
gt;
gt; you are giving suggestion to manually group the contents 10,20,30,15
gt; amp;12 am i correct?
gt;
gt; pl explain me in detail which would be helpful for me!
gt;
gt; thks!
gt;
gt; -via135
gt;
gt;
gt;
gt;
gt;
gt; Debra Dalgleish Wrote:
gt;
gt;gt;The Group command is for date and number fields, and won't work if a
gt;gt;field contains text or blank cells.
gt;gt;
gt;gt;You could manually group the items in the field, by selecting two or
gt;gt;more items in the pivot table, and choosing PivotTablegt;Group and Show
gt;gt;Detailgt;Group.
gt;gt;
gt;gt;Or, add a column to the source data table, and enter a Group label
gt;gt;there, for each record. Add that field to the pivot table.
gt;gt;
gt;gt;via135 wrote:
gt;gt;
gt;gt;gt;hi all!
gt;gt;gt;
gt;gt;gt;in my worksheet a particular field (COL) contains quot;two digit
gt;gt;gt;numbers,some alphabets amp; some alphanumeralsquot;..like
gt;gt;gt;(10,20,30,AA,BB,A1,B3,...).
gt;gt;gt;
gt;gt;gt;the problem is after creating a pivot table while i am trying to
gt;gt;
gt;gt;group
gt;gt;
gt;gt;gt;that particular filed i am getting the msg quot;can't group that fieldquot;.
gt;gt;gt;
gt;gt;gt;how to overcome the problem?
gt;gt;gt;
gt;gt;gt;help pl!
gt;gt;gt;
gt;gt;gt;-via135
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html