Appendix A. Building Formulas for Pivottables

Introducing Formulas

One of the most powerful techniques you can use to enhance PivotTable-based data analysis is custom calculations in your reports. Whether you create a new calculated field or one or more new calculated items within a field, custom calculations enable you to interrogate your data and return the exact information that you require.

To get the most out of custom calculations, you need to understand formulas: their components, types, and how to build them. In this appendix, you learn how to understand and work with formulas and functions. However, the formulas you use with a PivotTable differ in important ways from regular Excel worksheet formulas. This appendix highlights the differences ...

Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.