1 Reply Latest reply on Sep 11, 2018 9:32 AM by Ken Flerlage

    How to weigh different measures

    John Spirawk

      Hello,

       

      I'm looking for a way to set a weight for different measures in excel. Some background -> I work on a Sales Support team and I'm trying to make a quick dashboard to show sales capacity for each team.

       

      We factor in total sales, locations, potential, and another metric we calculate internally. The weights would be:

       

      Sales - 75%

      Locations - 10%

      Potential - 10%

      Metric - 5%

       

      I would then use that calculation to determine the over capacity for that team.