6 Replies Latest reply: Oct 29, 2014 4:23 PM by Jonathan Poole RSS

    Calculating average after removing min and max

      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)