Outlines (groups) within outlines

[DashboardNovice]

In the attached file, I am grouping by CLIN 0003 and 0004. I want summary rows to show so I put them at the top. So far so good.

But the problem is that the + sign is one row below the summary row. Not literally one row because there are collapsed rows, but I would like to + sign to appear on the same row as the summary row.

The only way to make the + sign appear on the same row as the summary row, is to place the summary row at the bottom of the rows that it pertains to. I don't like the looks of this when each level is expanded. So it seems like there is a trade off.

Is it possible to keep the summary row at the top of the data it is summarizing and also have the + sign appear on the same row?

 

[Luke M]

You can tell XL was designed by accountants, who were used to having totals. Thankfully, this is a easy switch. Go to Data, Outline group, and click on little arrow in bottom right.


Then, uncheck this option

And voila, the summaries now roll-up, not down.

 

[DashboardNovice]

You can tell XL was designed by accountants, who were used to having totals. Thankfully, this is a easy switch. Go to Data, Outline group, and click on little arrow in bottom right.
View attachment 9189

Then, uncheck this option
View attachment 9190
And voila, the summaries now roll-up, not down.

Nice. Exactly what I was looking for. It worked perfectly. Thank you.