2 Replies Latest reply on Jul 13, 2017 8:59 AM by Deepak Rai

    Average Reference Line Question

    Sila Chea

      Hello,

       

      I have data regarding meetings booked by our sales team and i had questions on average reference lines. Each sales teams are associated to a region (ex: 101 - Eastern, 102 - Eastern, etc...).

       

      I'm trying to get the average for the region but when i add the reference line, it gives me the average without dividing by how many territories that are under the region

       

      Also, when looking at the view on territory level, i'm also trying to add a line which will refer to the region average to see where they stand.

       

      I've attached a copy of the workbook

       

      Thank you