Pinterest Pixel

Field List & Areas

When working with Pivot Tables, one of the most crucial concepts is understanding how the Field List... read more

Download Excel Workbook
Bryan
Posted on

Overview

Field List & Areas | MyExcelOnline

When working with Pivot Tables, one of the most crucial concepts is understanding how the Field List and its different Areas work. Being able to utilize this correctly will spell the difference on how effective you can perform your analysis with Pivot Tables!

Let us go over the different sections:

  • Fields
  • Rows
  • Columns
  • Values
  • Report Filter

Exercise Workbook:

download excel workbookField-List-Areas.xlsx


Here is our initial data table:

Field List & Areas

STEP 1: Now the first part is the Fields section, which represents the column headings of our data source:

Field List & Areas

STEP 2: The Row labels show the unique fields on the left-hand side of our Pivot Table. Drag PRODUCTS to Rows to see how this looks like.

Field List & Areas

Now you can see our Products are listed on the Pivot Table.

Field List & Areas

STEP 3: The Column labels show the trend of your data. For example, this could be periods, trends, time, month, years.

Let us drag the SALES YEAR to the Columns

See also  Correlation in Excel - With Examples!

Field List & Areas

Now you can see the years 2012 – 2014 as the columns.

Field List & Areas

STEP 4: Values are fields that you want to calculate or quantify. Examples are sum (for sales), count (for number of units), average (for prices), and maximum/minimum (for values).

Let us drag SALES to Values

Field List & Areas

You will get the Sum of Sales values here for each Product-Year combination.

Field List & Areas

STEP 5: The last one is our Report Filters. These are optional fields that you want to drill down on. Examples are regions, periods, business units, or staff.

Drag both SALES REGION and SALES PERSON to the Filters area

Field List & Areas

Click on any filter and you will be able to filter your Pivot Table data according to your selection.

Field List & 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

See also  Editing a Calculated Item
Field List & Areas | MyExcelOnline
Field List & 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!