Pivot Table Error: 'CANNOT GROUP THAT SELECTION'

[Rhino_dance]

Please read this entire post first. I am getting an error which reads 'CANNOT GROUP THAT SELECTION' when trying to use the 'Group' feature on a field in a pivot table. I know all of the standard reasons when getting this error. These reasons are:
1) Blank cells in the data
2) Having the data source extended below the data so that it includes blank cells.
2) Having a mix of different data types in same field (e.g. text and numbers together)
3) Having a data type in a field that's formatted with a different data type (e.g. a number in a text field).

The problem is, I get this error no matter what, and with any data set I try. Even when I create a small sample data set with none of the above problems.

Attached is a screen print where I show a small sample data set and the pivot table that I created from that data set. The data source of the pivot table only includes the table as shown and does not include blank rows beneath. So it has none of the above problems. When I try to group on 'Product' I get the same error which reads 'CANNOT GROUP THAT SELECTION'. Can anyone shed light on what the problem might be? I am using Excel 2010.

Pivot_Wont_Group.jpg

[ChemistB]

You cannot group text. You can only group numbers.

[Rhino_dance]

I was thinking that 'Grouping' was similar to creating a 'Calculated Item'- which does allow the user to combine build an aggregated entry using text fields. Now I see that it's not. I see how I can solve this problem using a Calculated Item. Thanks very much for your reply.

[kbaruin]

Hi I am struggling to come up with a solution as to how to create dynamic charts for the set of data I have. I am neww to creating pivot tables, dynamic chart and names ranges. Here is the set if data I have.

ABC_Sheet_No AP1 Date Raised YEAR ABC_Raised Responded Closed Engine ACR
002 AP1 12/01/2012 2012 Y Y N 21001 91A
003 AP1 12/01/2012 2012 Y Y Y 21001 91A
34 AP1 20/01/2012 2012 Y Y Y 21001 43A
63 AP2 15/02/2012 2012 Y Y Y 21001 41A
65 AP2 16/02/2012 2012 Y Y Y 21001 41B
73 AP2 20/02/2012 2012 Y Y Y 21001 41A
86 AP2 22/02/2012 2012 Y Y Y 21001 44A
88 AP2 22/02/2012 2012 Y Y Y 21001 41A
89 AP2 22/02/2012 2012 Y Y Y 21001 41A
90 AP2 23/02/2012 2012 Y Y Y 21001 41A


this has got several other columns but I only included few here. I am trying to create a dyamic chart that shows no. of ABC's raised,responded, closed by ACR and in a monthly, weekly or yearly basis. I want a chart that has the option to show the chart by clicking the ACR no or by weekly,monthly, yearly basis etc. SO by selecting an option button for each(ACR no or by date) the charts has to change accordingly. Please help. I am badly in need of solutions for this. I am struggling

THanks in anticipation

[Cutter]

Hello kbaruin, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[kbaruin]

Sorry I am a new member. Will post as a new thread.

THanks

Hello kbaruin, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.