Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» PivotTable report - Grouping Text Fields

To group text fields:

1. Select a few items in a row field. In the example, items are selected from Customer Name.
2. Press Alt+Shift+Right Arrow.
OR
Right-click, select Group and Outline from the shortcut menu, and then Group.
3. In the new field, change the text Group1 by typing over it.
4. Repeat the steps above to add more groups and change the group text.
5. Type a new name for the new field on the gray title, and then click OK.
6. Drag the Customer Name field to Page (in the upper-left corner).

Note:
Only one new group field can be created. If you want to add more group fields to the same field (for example, to group customers by salesperson name or product), you must copy and paste the Customer Name column into the source data, change the heading title, and then group each field in the PivotTable report.
Screenshot // PivotTable report - Grouping Text Fields

PivotTable report - Grouping Text Fields
Rate this tip
12 34 5
  RATING: 2.53
  VIEWS: 21070
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation