3 Replies Latest reply on May 16, 2017 10:14 AM by Jim Dehner

    Total Weighted Average - Total

    Scott Li

      I'm having trouble summing up a weighted average calculation I created. Any insight would help.

       

      The calculation should be % of Total Orders * Total CT = Wtd Avg CT. I then want to sum up all of the last column by Type. No matter what I do, I can't seem to apply a subtotal correctly. I attached a workbook - version 9.1.

       

      Thanks!