How to calculate percentage in a pivot table (from a tally)?

[o0o0OoO0o0O0oo00o0O0]

Hi,

I have created the following pivot table. (Please see the excel file attached here).

I have used the pivot table to display Total Wins and Losses.
However, it seems I am unable to calculate "Win %" in the pivot table. I want to ONLY show the percentage of Wins (vs losses).

My original data is included in the attached file. It uses a 'tally' to record Wins and Losses.
Simply: If there is a '1' in the Win Column, that means a win. If there is a '0' it means a Loss.

Could someone kindly help me do this?

My EXCEL file: cumul raw separates.xlsx

Illustration of my data: http://imgur.com/mzHMGdz

To be clear, the pivot table shows "Character" and "Opponent".
So here it shows that "Fox vs 'Opponent:' C.Falcon" is 2 wins, and 0 losses. Instead of showing this, it should show his % win. So it should say 100%. Because Fox beat C.Falcon 2-0.

Ideally, I would like to add this function in the pivot table (if possible).

Hope you can understand!

[JosephP]

in the Fields, Items and Sets dropdown create a calculated field using 'W'/('W'+'L') and format it as percentage. you will probably want to use the pivot table options to hide error values ;-)

[o0o0OoO0o0O0oo00o0O0]

in the Fields, Items and Sets dropdown create a calculated field using 'W'/('W'+'L') and format it as percentage. you will probably want to use the pivot table options to hide error values ;-)

Sorry, but I don't know where the 'Fields, Items and Sets dropdown' is?

[JosephP]

on the Options tab in the PivotTable Tools group on the right of the ribbon when you have the pivot selected

[o0o0OoO0o0O0oo00o0O0]

on the Options tab in the PivotTable Tools group on the right of the ribbon when you have the pivot selected

And then it says 'formula' but it doesn't allow the formula helper thing where I can select which fields to calculate the average for.

How can I reference fields using this option?

If I put this formula: = (B6+C6)/B6

It says, "References, names, and arrays are not supported in PivotTable formulas"

[JosephP]

you can't use cell references-you select field names from the list or simply copy and paste this as the formula
='W'/('W'+'L')

[o0o0OoO0o0O0oo00o0O0]

you can't use cell references-you select field names from the list or simply copy and paste this as the formula
='W'/('W'+'L')

Thank you. I missed that part of your post.

And for hiding the DIV/0 errors?

[o0o0OoO0o0O0oo00o0O0]

Solved it. Thanks.
+rep added.