set analysis in chart

[#1]

Hi,

I've a difficult situation which i want to solve in the expression and not in the script.

column A :contains calculation with average of 21.16

column B: what I want to get is the value in column A  minus the high average

               (average of the rows of A above the average - in this case the white rows)

Thanks in advance

'A' AVG: 21.16

High 'A' AVG: 31.09

[MK_QSL]

Kindly provide Sample Apps or Sample Data !

[buzzy996]

can u try this,

create a variable = store ur max avg value in this field.

and in ur chart use field B = A - variable.

[Anonymous · Accepted solution]

Expression is:

A - avg(total  if(A>avg(total A), A))

[maxgro]

PFA