Pinterest Pixel

Change Sum View in Label Areas

Even with the same Pivot Table field setup, you can achieve different views in your Pivot Table... read more

Download Excel Workbook
Bryan
Posted on

Overview

Change Sum View in Label Areas | MyExcelOnline

Even with the same Pivot Table field setup, you can achieve different views in your Pivot Table just by changing the Sum of Values field. Let us explore how to change sum view in label areas that we will get from tweaking the Pivot Table!

 

Exercise Workbook:

download excel workbookChange-Sum-views-in-Label-areas.xlsx


STEP 1: Here is our Pivot Table. Drag the Sales field to the Values area.

Change Sum View in Label Areas

Notice we have the Sum of Values field added as well into the Columns area. This happens because we have more than one metric in our Values area.

Change Sum View in Label Areas

STEP 2: Let us change the second Sum of Sales field into Count. Click on the arrow and select Value Field Settings

Change Sum View in Label Areas

STEP 3: Select Count and click OK

Change Sum View in Label Areas

STEP 4: Now that we have our count, drag the Sum of Values field to the Rows area and see what happens!

Change Sum View in Label Areas

STEP 5: We have a completely different view. Now try moving the Sum of Values field above the SALES REGION field

See also  Group By Custom Dates With Excel Pivot Tables

Change Sum View in Label Areas

And there you have the different views just by moving the Sum of Values field!

Change Sum View in Label Areas

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Change Sum View in Label Areas | MyExcelOnline
Change Sum View in Label Areas | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!