Pivot Field Calc: average win for grouped data

[michellepace]

Hi there,

What I need is simply to obtain the "average winner" (where a winner is defined as Profit > 0) for each group. I need this Calculated Field to be part of the pivot table. I can understand why my attempt is not working when I ungroup the data... however does anyone know how I can successfully calculated this field?

Q02 Pivot calc - avg winner.xlsx

Avg Winner Calc.png

Thanks in advance,
Michelle

[michellepace]

I'm actually not even sure why my SUM of WINS does not work :-/ ...especially when I ungroup the data - for this column at least it looks as if it should work