Excel Pivot Table: How to Substract Columns

This Excel tutorial will help you understand how to subtract columns in a Pivot Table.

👉 Step 1: Find Subtraction in the Menu
To subtract a column from another, in this tutorial, we'll be subtracting the "Cost of Deduction" from the "Sum of Personal Cost." First, go to Pivot Table Analyze - Field, Items & Sets - Calculated Field.
This will open the formula modal, allowing you to input the necessary details.

👉 Step 2: Subtraction Method
After you have selected the columns in your Pivot Table that you want to subtract in your formula and added the minus sign, a new column will be displayed as the result.

💡 Need Help or More Tips?
Got questions? Need more help? Just leave a comment below!

Timestamp:
00:00 Intro
00:12 Subtraction Calculation
00:38 Subtraction Result

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: 💰 Compound interest calculator templa...
🎥 Common errors: 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: How to use UPPER in Excel
🎥 Regular functions explained: BASIC EXCEL FUNCTIONS

• #education
• #excel_pivot_table
• #pivot_table_tutorial
• #excel_data_analysis
• #subtract_columns_in_excel
• #excel_formulas
• #excel_tips_and_tricks
• #data_summarization_in_excel
• #pivot_table_examples
• #excel_calculations
• #microsoft_excel_tutorial
• #excel_data_management
• #excel_spreadsheet_tutorial
• #excel_pivot_table_subtract_columns
• #excel_pivot_table_one_column_minus_another
• #how_to_subtract_two_columns_in_excel_pivot_table
• #how_to_subtract_in_excel_pivot_table