Скачать или смотреть Subtotal certain rows in Pivot Tables

00:00 Add up items within a Pivot Table column
00:11 Where to click to see the calculated item option
00:23 Name the new subtotal for the Pivot Table
00:35 Sum the offnet mobile operators
00:50 Create more than one calculated item in a single Pivot
01:18 Double counting problem in the Pivot Table with items

Using the Calculated item feature in Excel Pivot Tables to create a subtotal of items within a single field. In this case it is adding up the costs for all the on net and off net calls to mobile operators as a grouping.

Note the we rather recommend you use    • Custom grouping text in a Pivot Table- gro...   to achieve this, as it is safer.