Hi guys,

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

	A	B
1	Win	Lose
2	Win	Win
3	Win	Win
4	Win	Win
5	Win	Lose
6	Win	Lose
7	Win	Win
8	Win	Lose
9	Win	Win
10	Win	Lose
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.