![]() If you want a more specific demonstration, provide us with some simple sample data, 2 or 3 rows for each category, subscategory and we can show you how to do it in PivotTables. There are different styles of pivot table layouts that you can apply to make them look closer to your example. I was going to suggest Pivot Tables also. The Column C subtotal acquires priority over the column B subtotal by being above it if I collapse it, the Column B subtotal disappears.Īppreciate any guidance toward a solution or work-around. This is not just ugly and confusing, it's dysfunctional. When I get to the third level, the column C subtotals appear on a row ABOVE the column B subtotal, instead of below, where I want them (I'm unchecking Summary below data). I've carefully sorted the dataset (which is not in an Excel table) and followed the instructions I can find online as best I can, but whatever I try the same problem keeps occurring, as illustrated in the image below. ![]() I read that you can nest up to eight levels of subtotals in Excel, but I can't seem to get past two. I am trying to make a budget spreadsheet with three levels of subtotals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |