Pivot Table Function

shaz77_2

Hi All,

I have a simple table that has one team that has played 4 games, won 2 and lost 2. How can I insert into the pivot table a new field that works out the % of games won?

Thanks

EchoLocation

Assuming your data has two columns (Team and Result)...

Add the Team field as a row and the Result field as a Column, then use a custom Field Value setting, Summarize by Count and Show values as '% of row'