0 Replies Latest reply on Oct 16, 2012 4:17 PM by Nayana Wagle

    How do I make an aggregate value a weighted average instead of a simple average?

    Nayana Wagle

      This is possibly a fairly common question - but I couldn't find a link that talked about this - so figured I'd ask.

       

      I have a hierarchy set up where a Line of Business has multiple Departments under it.

       

      Department A is under LOB1 and has a profit margin of 10% on a sale of $100,000.

      Department B is under LOB1 and has a profit margin of 7% on a sale of $1,000,000.

       

      Now I have a table that shows the profit margin by LOB.

      The profit margin LOB1  it takes a simple average of 10% and 7% and says my LOB profit margin is 8.5%. But obviously that's not right. How do I make Tableau take the sale value into consideration?