KPI independent from Section Access

[ruben_moya]

Dear Experts,

I have a dashboard where Managers can see data related only to their stores thanks to Section Access and it works great. 

They have recently asked me to be able to see the percentage of sales that certain store represent within the total of the company. Since they can only see a limited part of the data, I don't really know how to deal with that request.

I've thought about saving that information previously in a qvd file, however, that data needs to be variable according to the selections made by the user.

I've also thought about creating a duplicate of the model  not connected to the main one so it doesn't get affected by the Section Access. Somehow, I'd need create a connection between the fields of both models so, when one field gets selected the other one replicates the action.

I tried to explain myself as well as I could, let me know if you have any idea about how to deal with this scenario.

Thanks in advance!

[jwjackso · Accepted solution]

Create a dummy store that is the aggregation of all stores and grant every manager access to the dummy store.  Use the manager's store/dummy store to get their percentage of sales.

[ruben_moya]

Hi @jwjackso ,

that's a smart and simple approach, thanks a lot! I will also need to add all the fields they will use to filter de data in the aggregation, let's see if all the extra rows delays the load.

Thanks!