|
» PivotTable report - Grouping Text Fields
CATEGORY: Excel Pivot Tables |
VERSIONS: All Microsoft Excel Versions |
|
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 |
  |
|
RATING:
2.53
VIEWS: 21070 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Yes, You Can Time the Market!
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Writing Excel Macros with VBA, 2nd Edition
Related MS EXCEL TIPS:
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.
