Summarizing portions of rows in a form?
Summary: I am trying to figure out how to create summary lines in a form without blowing up the form.
Content (required): Due to security requirements, a large number of our planners are not allowed to view total company data so do not have access to view that summary level member. The issue is that when doing planning on a contract that can have activity in many zero level entities, they would like to be able to see the total activity for the contract and all of the entities that they do have access to view.
This becomes an issue on a form when we have one line for multiple accounts with a Lvl0Descendant of Total Company for the entities. I can't split out the accounts into different rows on the form or the accounts wouldn't be grouped by the individual entities, but I can't figure out how to get individual formulas for each account with this design. The row design is shown below where &EntityHierarchy is the upper level member that the user would not have access to view. In place of having that there, I would like to have row