Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.