Hi!
I have a problem where I am trying to calculate the difference between two columns that have the condition "% of Parent Row Total" in the value field settings. I want to get the difference between the two but it uses the underlying values instead of the calculated fields values.
I have attached an excel here with dummy data to shBook2.xlsxow what i mean.
Thanks for any help!
P
I think I may not be understanding. The formula you are using does give the difference between Sum of Data 3 and Sum of Data 2.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Here!
Put this formula in cell E2 and Drag Down.
Go to change source data on the Pivot Table and Included the added helper column and get it on the Values Area of the Pivot Table
=(D2/SUMIF($A$2:$A$16,A2,$D$2:$D$16)-(C2/SUMIF($A$2:$A$16,A2,$C$2:$C$16)))
It will look like this -
Cheers!
Deep Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks