FIND AVERAGE OF MIN

[sadath]

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 ,

 

[SQUIDD]

Hi

Do i understand you correctly?

=AVERAGEIF(B:B,MIN(B:B),C:C)

Do you have to refer to the table?

Dave

 

[SQUIDD]

or this done the table for me

=AVERAGEIF(Table1[[#All],[TRX NO]],MIN(Table1[[#All],[TRX NO]]),Table1[[#All],[Values]])

 

[SQUIDD]

OK

So now i see what you are trying to acomplish now.

I mis-understood.