Pivot - Calculated field formula?

Hi guys,

If i have a pivot of column's A1:A10 and B1:B10, like so:

Please Login or Register  to view this content.

And I want to work out the percentage of a wins in b ie 10:5 = 50%, is there a formula i can use when Creating a field on a pivot?

I know that they are Char strings so i can't apply numeric filters etc but am hoping an element of the formula can fixed that?

Cheers, Have a good day all.

Try: =COUNTIF(B:B, "win")/(COUNTIF(B:B, "win")+COUNTIF(B:B, "Lose"))

Im adding to a pivot so have to use the column label instead of the cell ref B:B, Its trowing up an error

=COUNTIF( 'Win / Lose' , "Win")/COUNTIF( 'Win / Lose' , "win")+COUNTIF( 'Win / Lose' , "Lose"))

Shouldn't the formula have a ref to A ie say A is filled every time that gives you the ref to use against B.

Thanks again for the help

I was trying not to but ended up just using numeric ref's on the data sheet so i could easily use a % formula to get my figure on the pivot, Kind of a shortcut which i dont like but can't spend all day on one little issue

I have another fairly easy question, should i open a new thread or post here.. its not related to pivots but macro's and formatting