This content has been marked as final. Show 6 replies
I'm working on QMC and I have a question about an app I'm creating.
Let's simplify to explain.
My app has data about selling of a company, in this company there are a chief and two agents, and the data of the app are about the selling performances of the two agents. Here a very simple example:
The app has more datas obviously, and many graphics in differents sheets.
My question is:
I would like that the chief can see the whole app with the data of the two agents, I would like that the agents can see the whole app as the chief (same sheets and graphics), but only his performance (not allowed to see the performances of the other agent): for example in a sheet with a KPI sum(performance), chief sees xa+xb, A sees xa, B sees xb, and A and B are not allowed to see each other performances or the sum of them.
chief sees all sheets and graph, and all the data. Example: sheet1, KPI sum(performance), result: xa+xb
A sees all the sheets and graph, but only his performances. Example: sheet1, KPI sum(performance), result: xa
B sees all the sheets and graph, but only his performances. Example: sheet1, KPI sum(performance), result: xb
Is there any way to do this?
Thanks a lot