Hi! I'm working in a pivot table and I'm stumped.
I have 2 columns that are both numbers formatted as:
I am trying to calculate the difference.
The correct answers in the third column would be 0.0%, 0.9%, 1.4%, 1.3%, -1.2%, -1.0%
Hoping someone can help me figure out the right combo to get the above results.
Thanks!
I have 2 columns that are both numbers formatted as:
- Summarize Values by = Sum
- Show Values As = % of Parent Row Total
I am trying to calculate the difference.
The correct answers in the third column would be 0.0%, 0.9%, 1.4%, 1.3%, -1.2%, -1.0%
Hoping someone can help me figure out the right combo to get the above results.
Thanks!