PIVOT TABLE calculations: Remove calculated field (Part 2: remove calculated rows or columns)
Pivot table calculated field:
Our last video showed how to add calculated field in pivot table. This beginners' tutorial provides is the second in our Pivot Table calculations series and shows how to remove a calculated field to your Pivot Table (how to remove calculated rows and columns). This easy beginners tutorial will show you how to remove those calculations in pivot tables.
You can find PIVOT TABLE calculations: Beginners Tutorial (Part 1: add calculated rows or columns) here: • PIVOT TABLE calculations: Add calcula...
0:00 Introduction
0:45 Setup and question asked
1:02 Method to remove calculated rows or columns
1:30 Removing calculated field
1:56 Removing calculated item
2:17 Final thoughts
The file I have used is the same as for my the Part 1: Pivot table calculations video, which available to download from my Google Drive. Try following along with both videos or use it for reference in your own time.
Download the file here: https://drive.google.com/file/d/1vK5h...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
You can find all our Pivot Table videos in the following playlist: • Playlist
Or here are the links to individual videos; check them out!
Guide to Pivot Tables video: • Beginners guide to Pivot Tables: lear...
Introduction to Pivot Tables: • Learn Pivot Tables in 7 Minutes | Int...
Issues with PIVOT TABLES - fixing common errors: • Issues with PIVOT TABLES - fixing com...
Pivot Charts: • Introduction to PIVOT CHARTS. Learn t...
Pivot Tables and Slicers: • Excel Pivot Table Slicers: Learn how ...
