5 Replies Latest reply on Jul 11, 2018 7:24 AM by Shinichiro Murakami

    how to do weighted average

    Tony Fahd

      hi i am attaching a workbook where i have location, number of customers at each location who purchases a product with total cost. i like to get weighted average cost by product for each of my locations. since i don't have the detailed customers, Tableau will do a normal average of cost. i like to get weighted average instead.

       

      the average cost in the above case is 143.3 which is not weighted. how can i get a weighted average. Thanks