I am trying to find a clean way to calculate average in a pivot chart after removing the min and max values of each row. Does anyone have any suggestions?
An expression like:
( sum(value) - max(value) - min(value) ) / (count(value)-2)
What's wrong with your expression? Alternatively, you can also use set analysis.
Yes, the expression does seem to be working - it's just not getting the value I would expect. Could you demonstrate the set analysis way?
I would first investigate why your expression is not working as of now - set analysis would do nothing else than translating your expression into a set modifier.
Which part is incorrect ? The denominator , numerator or both ? I would split apart the components and test each one. There is really only 3 or 4 values that need validating.
yah it's working fine, now ended up being a bracket misplacement
cool... mark your last response as correct and close er' down.
Retrieving data ...