About mikeng

Dear all, 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. Regards, Mike ... View more

Hi all, I'm having trouble with the sum function. I have the reference module [A] as below: Then I need to sum in Module [B] that only select the "SGA" element in "P&L Total" (which is a list) but I can't. The line item needs to insert the formula is "SGA" in the image below:   I've tried all sum, select, lookup, select&sum to insert the ".SGA" but the formula still doesn't work. Please help!   Thanks very much! Best regards, Mike ... View more