O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Glossary of PivotTable Terms

Argument

A value that is used as an input for a function and which the function uses to calculate a result. The arguments of a function must correspond to the function's parameters.

Arithmetic Formula

A formula that combines numeric operands — numeric constants, functions that return numeric results, and fields or items that contain numeric values — with mathematical operators to perform a calculation.

AutoFormat

A collection of formatting options — alignments, fonts, borders, and patterns — that Excel defines for different areas of a PivotTable.

Background Query

A query that Excel executes behind the scenes so that you can continue to perform other work in Excel.

Base Field

In a running total summary calculation, the field ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required