Skip to content

Stockertim Dictionary · Technology · Business

Values area

Also called values field, value field, data area

In short

The part of a pivot table layout that holds the numbers being summarised, together with the calculation applied to them, such as sum, count or average.

  • Intermediate
  • Concept
  • Checked

In detail

A pivot table is built by placing fields in four areas: rows, columns, filters and values. The first three decide how the data is grouped and which records are included. The values area decides what is measured in each cell of the resulting grid. Dropping an Amount field there with Sum gives total amount for every combination of row and column labels.

Each value field carries a summary function, chosen in its settings: sum, count, average, maximum, minimum, product, standard deviation and a few more. Numeric fields usually start as Sum, but in Excel a field containing any blank or text entries starts as Count, which is a frequent source of confusion when a report shows how many sales there were instead of how much they were worth. The same field can be added twice, once as a sum and once as a count, to show both.

A second layer, Show Values As, changes how the summarised numbers are presented without changing the calculation beneath: as a percentage of the grand total, of the row or column total, as a running total, or as the difference from a chosen item such as last month. Number formatting set in the value field settings survives refreshes, unlike formatting applied to cells by hand.

Averages need care. An average in the values area is calculated from the underlying records, so it weights large groups more heavily than an average of the group averages would. That is usually correct, but it surprises people who compare the pivot with a manual average of subtotals.

Worked example

A bicycle shop in Utrecht has 6 sales: three in May worth 200, 300 and 400, and three in June worth 100, 100 and 400. Amount goes in the values area.

  1. Sum for May: 200 + 300 + 400 = 900
  2. Sum for June: 100 + 100 + 400 = 600
  3. Average of all six sales: 1,500 / 6 = 250

The same field gives totals of 900 and 600 by month and an overall average of 250, depending on the summary chosen.

In practice

Analysts set the summary and number format of every value field deliberately, and label the field clearly, for example Sum of Amount renamed to Sales value, so readers know what each figure means.

Watch out

  • A field with blanks or text may default to Count instead of Sum.
  • Show Values As changes the display, so a column of percentages can still be built from sums or counts.

Learn it properly

Official sources

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English