Pivot table: difference between two columns
Solved
jds2016
Posted messages
14
Status
Membre
-
sal -
sal -
Hello,
I want to add in column D the difference between the values in column B and column C, how can I do that?
Here is the link to my pivot table: http://www.cjoint.com/c/GFCpIK0FkjG
Thank you in advance :)
Configuration: Windows / Chrome 59.0.3071.115
I want to add in column D the difference between the values in column B and column C, how can I do that?
Here is the link to my pivot table: http://www.cjoint.com/c/GFCpIK0FkjG
Thank you in advance :)
Configuration: Windows / Chrome 59.0.3071.115
2 réponses
PIVOT TABLE TOOLS / ANALYSIS /
Calculations / Fields, items, and sets / Calculated field
In the [Name] window, replace "Field1" with "Difference"
In the [Formula] window, enter =BUDGET-REALIZED and confirm.
https://www.cjoint.com/c/GFCp4DbYTXw
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
Calculations / Fields, items, and sets / Calculated field
In the [Name] window, replace "Field1" with "Difference"
In the [Formula] window, enter =BUDGET-REALIZED and confirm.
https://www.cjoint.com/c/GFCp4DbYTXw
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
Thank you very much, Raymond!