LinkBack URL
About LinkBacks
Hello,
I would like to calcualte the difference between two fields in a pivot table.
Market Count(ID1) Count(ID2) Difference
xyz 15 13 2
I tried to create a formula taking ID1 - ID2 but the value comes back as 0.
Any ideas?
Hello,
I would like to calcualte the difference between two fields in a pivot table.
Market Count(ID1) Count(ID2) Difference
xyz 15 13 2
I tried to create a formula taking ID1 - ID2 but the value comes back as 0.
Any ideas?
Hi There,
Please find my answers in attached workbook. I hope this is what you were looking for.
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
You can add the additional column by referring to the below steps.
Once you are on Pivot table sheet, "Click on "Field, Items, & Sets" option from "ANALYZE" category and then click on Calculated Filed.
Calculated Field.png
Post that, In Formula tab, type or insert "=Column-Count" and name it as Difference (as per your requirement).
Calculated Field-2.png
Let me know if it solved your purpose.
I had tried that but receive 0 results. Here is an image of my pivot.
pivot.jpg
Hi..Could you please upload your attachment here...or Please refer to my last post on this thread.....Follow each steps to add additional column (you dont need to add manually just follow the steps mentioned in the images)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks