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

    Calculating average after removing min and max

    Tyler Vranizan

      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)