1 Reply Latest reply on Jul 12, 2012 12:24 PM by Janet Shen

    How can I create a weighted average within an average?

    Jane Kim

      Hi, I have a dataset that shows product sales by customer but I need to create some aggregate metrics at the customer level.  I can do it by creating a pivot table in Excel and re-importing it into Tableau but I would like to create a solution all within 1 dataset in Tableau.

       

      I need to basically create an average within an average.  In this case, the average units sold per customer:

      Avg within avg.png

       

      I'd like this to be done within a calculated field so I can add it as a metric to a table.

       

      Thank you for all your help!!  I'm new to Tableau and definitely not a power user so apologies in advance if this has been answered 5,000 times over.