Selective access: Sum/Total does not work!
My company is at the end of the project and we've just found out the Selective access cannot show the total budget amount! Particularly, we have many expense category and for example Labor expense include personnel costs (owner is HR department) and non-personnel costs (owner is general affair department) and it's a must that they cannot see each other budgets. We've already set up the selective access for both but the PROBLEM is each one can see their items under their owned category but CANNOT SEE THE TOTAL of their budget.
Please kindly advise: Is there any solution to this? Right now the only solution for us is to DISABLE THE SELECTIVE ACCESS and duplicate a lot of modules with subsets and then duplicates the dashboard for each owner and that is very frustrating for both Building and then Maintaining the model. What's the use of selective access if it can not show the filtered sum/total anyway?
Thanks in advance.