Microsoft Excel

Calculated Items in an Excel PivotTable

Chris Menard

24 Mar 2022 — 1 min read

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

Excel Advanced - Calculated Items in a PivotTable - using percentages

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.

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.