Share this Page URL
Help

When I try to group a field, I get an error message - Pg. 247

Why can't I group my month fields into quarters? 247 Solution One of the following scenarios can trigger this error message: The field you are trying to group is a text field. The field you are trying to group is a date field but contains text or blank cells. The field you are trying to group is a date field but is being recognized by Excel as text. The field you are trying to group is in the page area of your pivot table. To resolve this issue, take the following steps: 1. Go to your data source and make sure the field you are trying to group is formatted as Date and does not contain blanks cells or cells with text in them. Remove all text, format the cells in the field as Date, and fill in all blank cells with a dummy date. 2. Highlight the column that contains the field you are trying to group. Go up to the application menu and select Data, Text to Columns. This will activate the Text to Columns Wizard. All you have to do in this wizard is click Next, click Next again, and then click Finish. 3. Go back to your pivot table, right-click, and select Refresh Data. 4. If the field you are trying to group is in the page area of your pivot table, move the field to the row or column area. 5. At this point, you will be able to group the data items in your field. After the field is grouped, you can move it back to the page field if needed. Why can't I group my month fields into quarters? Problem Instead of having one field that contains months, you have several fields that represent each month. Your pivot table looks similar to the one shown in Figure A.1. Figure A.1 Instead of one field that contains months, each month is its own field. A