Calculated Items in an Excel PivotTable
Posted on: 03/25/2022
Excel PivotTables have calculated fields and calculated items. In this video, I will take a field called Year, which has 2022 and 2021 in it and create a calculated item. In case you are wondering, what is the difference between a calculated field and a calculated item? That is easy to explain. Your data has a header row that contains fields. The items in the field are items.

Excel - Calculated Item
YouTube Video
Video Chapters
-
0:00 Introduction
-
0:17 Calculated field and items explained
-
1:26 Insert Pivot Table
-
2:25 Number format
-
2:57 Calculated Item
-
4:42 Add percentages - TIP
Example of a Calculated Item
If you were tracking employees, you could have a field called Department. Listed below department is Accounting, Marketing, Sales, Customer Service. Those four are items, but the department is the field.
Recent Excel Articles
Chris Menard
Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with other 750 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 million viewers have appreciated.
Categories