1 Reply Latest reply: Jul 9, 2016 5:39 AM by Tresesco B RSS

    Show Company Avg in Section Access

    vibol chea

      Hello,

       

      Currently I have limit each sales rep to their data only but I'd like to show a graph line of company avg versus theirs.  I'm guessing it needs to be scripted in the load somehow.  Please advise.

       

      Thanks,

       

      Vibol

        • Re: Show Company Avg in Section Access
          Tresesco B

          Yes just create a table with a KEY and the average, may be like:

           

          Avg:

          Load

              Autonumber(Field1&Field2&Field3) as KEY,

              Avg(Sales) as CompanyAvgSales

          resident <> Group by Field1, Field2, Field3;

           

          Assuming Field4 (which is not there in the composite key) is your sale rep field.

           

          Now create a similar key in your transnational table, it should work.