How can I restrict data by users?

[#1]

Hi,

I would like to know how can I restrict accesses by users. I read some things about Section Access, but I don't understand how can I apply it to my case.

I have a table with 2 columns:

KeyAccountManagerName, ClientNumber

John, 2548

Tom, 7894

Anna, 6698

I would like to define that each KAM only can see his/her client's detailed data. However, I would like that each KAM could see others KAM clients data but only aggregated data, not the detailed data.

What I mean is, for example, John can see all data related with his customers like details of sales amount by month, but only can see the aggregated data from Tom's clients, like for example the total sales amount of his clients.

Thanks in advance for your help!

Rgds,

Mariana

[sparur]

Hello Mariana.
You should create 2 different tables. One table with detailed data and other with aggregated data. Then on the first table you can use Section Access for restricting data by KAM.

[#3]

Thanks!