Forum Discussion
Solved
Pivot Table Help Subtract Values
- Windows 10 OS Excel Desktop Latest Version, Sample File Attached
- I am trying to take the total feet from the Coil_input Table and subtract it from the total feet (From Order_Input) calculated in the pivot table. The goal is to see the difference as dynamic data inside the pivot table. There are not date call outs in the coil_input table and does not need to be.
- I haven't been able to combine the tables into one pivot table and get the data to look correct it just turns into a mess and doesn't allow for relationships to work very well.
- I cheated it in a previous version and put a vlookup with some simple math formula to the right of the pivot table to make it work but it was to much formula manipulation anytime you change the slicers in the pivot table.
2 Replies
I appreciate the solution. That is going to be my best option it appears.
Do you have any references for me to be able to do that same type of query with other data sets?
