How to Create a Calculated Item in Excel Pivot Table
When you add fields to a pivot table, you can show or hide that field's pivot items. In addition to the existing items, you can create calculated items for a pivot field.
This video shows how to create a calculated item, and display it in the pivot table. You'll also hear the disadvantages to using calculated items.
Visit my Contextures site for a sample workbook and written instructions.
https://www.contextures.com/excelpivo...