1 Reply Latest reply on Aug 18, 2016 1:12 PM by Patrick A Van Der Hyde

    Comparing Sales Metrics for Two Different Date Ranges in Same Worksheet/Dashboard

    Alan Rice

      Hello,

       

      I am trying to create a dashboard for our sales director to easily identify sales reps whose current month metrics are down vs. their prior 2 month average. As of now, I have two worksheets created that show Rep > Account > Metrics (# of Sales, Sales $, Profit $, Profit %) one of which is the average of their prior two months performance and one that is current MTD. Is there a way on the dashboard, to take the difference between the two worksheets? If this is not possible, is there a way for me to group these two different date ranges on the same worksheet to show these 4 metrics for each rep/account for both date ranges as well as calculate the difference between the two?

       

      Any help would be greatly appreciated.

       

      Alan