Office 2019 For Dummies by Wallace Wang

Author:Wallace Wang
Language: eng
Format: epub
ISBN: 9781119514022
Publisher: Wiley
Published: 2018-10-02T00:00:00+00:00

Rearranging labels in a pivot table

A pivot table organizes data according to your spreadsheet’s column headings (which appear in a pivot table as row labels). The pivot table shown in Figure 10-18 shows sales divided by salesperson. Each salesperson’s amounts are further divided by sales region and the names of the products sold.

However, you may be more interested in seeing the sales organized by sales region. To do this, you can modify which column heading your pivot table uses to organize your data first. To rearrange column headings in a pivot table, follow these steps:

Click the pivot table you want to rearrange.

The PivotTable Tools heading displays an Analyze tab and a Design tab.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.