When Calculated Items Collide

In addition to the regular items in a pivot table, you can also create calculated items, in one or more of the pivot fields. In this pivot table, we're summarizing data about insurance policies, with the number of new, cancelled, and existing policies in five regions.