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.