porkchops2
New Member
- Joined
- Nov 5, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am struggling to figure out how to generate a calculated field within my pivot table. Below is an example of my pivot table and the Discrepancy column is what I need to generate through a formula. I've also included a copy of my source data. I need to know when the total of the line discounts for an invoice do not match with the discount amount for an invoice.