Hi guys,
If i have a pivot of column's A1:A10 and B1:B10, like so:
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?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
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.
Bookmarks