I have a report with a table containing hierarchical data of organizations and employees. Under an organization there can be employees and/or other organizations. When I try to do a recursive sum on expenses incurred by an employee the report fails to return a total ONLY when the groups do not have their visibility set to hidden. If I hide the groups and select a toggle item then the recursive sum works, and a total is returned. What could be the issue here?