Chapter 10. CREATING CUSTOM PIVOTTABLE CALCULATIONS
Introducing Custom Calculations
A custom calculation is a formula that you define yourself to produce PivotTable values that would not otherwise appear in the report if you used only the source data fields and Excel's built-in summary calculations. Custom calculations enable you to extend your data analysis to include results that are specific to your needs.
For example, suppose your PivotTable shows employee sales by quarter and you want to award a 10 percent bonus to each employee with sales of more than $25,000 in any quarter. You can create a custom calculation that checks for sales greater than $25,000 and then multiplies those by 0.1 to get the bonus number.
A custom calculation is an Excel ...
Get Excel® PivotTables and PivotCharts: Your visual blueprint™ for creatingdynamic spreadsheets, 2nd Edition 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.
