7 Replies Latest reply on Aug 30, 2018 5:31 AM by Samuel Mustapha

    How to use AVERAGEIF in Tableau??

    Jesse Zhang

      First time posting here. Apologize if I am missing the format.

       

      Hypothetically, I have a data set with 3 customers under the "CUSTOMER" dimension, A, B and C. There is "SPENDING" under measurement, within that, A spent $100, B spent $101, C spent $102. I did a simple AVG ([SPENDING]) but now I also want to show the AVG (SPENDING) without customer B. How can I do that?

       

      Thanks.