Section Access vs Complete data

[#1]

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.

[pover · Accepted solution]

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.