Standard Pivot Tables have a simple feature for creating calculated items.
you could think of a calculated item as “virtual rows” in the source data.
A calculated item will not appear in the field list window.
Instead, it will appear as an item in the field for which it is defined.
The pivot table displays the correct regional totals, including the new region “Southeast”.
Fields
The source data contains three fields: Date, Region, and Sales.
Note the field list does not include the calculated item.
Excel will add these automatically when you hit the Insert Field button or double-click a field in the list.
