Try out the drill down group. Its a type of dimension that you create under the master items area (3rd tab on the left) under dimesions. You can use it in a table or a visualization. It will show the managerial totals and the you can drill down to see the lower level sums. When you are not in edit mode you can click the values and drill down.