How to calculate difference in pivot table?

[Frost32]

Hello guys, i would like to ask you how can i calculate difference between of numbers in those 2 columns in pivot table? For example, make 3rd column where is 663-0=663 3cd2e9cd54f44e609a0b0e4038a4d297.png

[JeteMc]

Assuming that To Loose and To Win are the field names:
1) From the Pivot Tables Tools tab (Options sub tab) select Fields, Items & Sets,
2) Select Calculated Field,
3) After assigning a field name the formula would be ='To Loose'-'To Win'
If you need more help I suggest uploading the spreadsheet from which the screenshot in post #1 was taken. To upload a spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[Frost32]

Assuming that To Loose and To Win are the field names:
1) From the Pivot Tables Tools tab (Options sub tab) select Fields, Items & Sets,
2) Select Calculated Field,
3) After assigning a field name the formula would be ='To Loose'-'To Win'
If you need more help I suggest uploading the spreadsheet from which the screenshot in post #1 was taken. To upload a spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

Thank you very much man! I didn't even know about that tab and pivot table had such features.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved', assuming it is, using the thread tools link above your first post. I hope that you have a blessed day.