This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Using Calculations Other Than Sum
Problem: It is relatively easy to change the calculation in regular pivot tables. It is impossible to change the calculation in OLAP pivot tables. There is a way to change the calculation in a PowerPivot pivot table, although it is hard to find:
Strategy: Go to the Sum of Revenue field in the Values drop zone of the PowerPivot Field List. Click the drop-down arrow to open the flyout menu.
The third item from the bottom of the flyout menu is Summarize By. Open this flyout menu to choose between Sum, Count, Min, Max, and Average.
Figure 970 You can choose from these five calculations.