Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Suppose Div 1 has salespeople A,B, C
A made 50, B made 30, and C made 20
With Section Access, A is limited to the records under his name.
But if I want to get the % compared to the whole Div (50/100=50%), how do I get it?
My understanding is that data is still there, and I tried "all" and "total" but didn't work.
Thanks in advance.
No, the unrelated data is not there after section access. What I've done in this case is load another table in the script that is not linked to the salesperson. The additional table contains the total sales of each division and is linked to the rest of the model by the division.
Regards.
No, the unrelated data is not there after section access. What I've done in this case is load another table in the script that is not linked to the salesperson. The additional table contains the total sales of each division and is linked to the rest of the model by the division.
Regards.