1 Reply Latest reply on Oct 5, 2018 9:15 AM by Jim Dehner

    How can I calculate an average excluding values?

    Juan Pablo Trujillo

      Hello, I am relatively new in Tableau 2018.2 and I need to know how can I calculate an average of selected values in a row. In the following example I want to calculate the average of all the values in the row excluding the first and the last value.

       

      For Example in the case of ago-18 the correct average should be 12.5%.

       

      Any suggestions would really help. Thank You.