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