I am trying to find average of min values of each TRXNO
pivot table retrues wrong value (ie for D02 should be 1756 ie average of 2848,2555,658,2680 &39) instead of 39
i tried Avg:=averagex(values(Table1[TRX NO]),min(Table1[Values]))
and Avg:=averagex(ADDCOLUMNS(values(Table1[TRX NO]),"Min",min(Table1[Values])),[Min])
result is same ,