Subtracting between Columns in a Pivot Table

**Alewis06** · 03-11-2021, 05:08 PM

The attached is a flat file representation of some pivot table results I have. I want to subtract Column C from Column B and place the results in Column D. How do I formulate that Calculated Field?

**NeedForExcel** · 03-12-2021, 12:30 AM

Hi,

I am assuming instead of these normal columns these are supposed to be Pivot Table Columns in your actual sheet.

There is something called a Calculated Column where you can perform operations using Pivot Table columns. You can use that feature

https://www.contextures.com/excel-pi...ted-field.html

**Alewis06** · 03-12-2021, 10:29 AM

You're right, it does represent the pivot table columns. I am sure it would have been better to include my actual pivot table but it's a lot to scrub. Thank you for trying to help. I found what I needed in this thread
https://www.excelforum.com/excel-cha...ml#post5486528

Subtracting between Columns in a Pivot Table

LinkBack

Thread Tools

Rate This Thread

Display

Subtracting between Columns in a Pivot Table

Re: Subtracting between Columns in a Pivot Table

Re: Subtracting between Columns in a Pivot Table

Thread Information

Users Browsing this Thread

Similar Threads

Subtracting two pivot table columns based on a count

[SOLVED] Subtracting one sum of counts from another sum of counts in a pivot table

Adding manual columns next to pivot tables and pulling pivot table data for formulas

Adding additional columns inside a pivot table to calculate rates from pivot table

Pivot table grouped data: Conditional formatting, sorting and selective subtracting

Subtracting dates in a Pivot Table

[SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions