Multiple total rows in tables
Wouldn't it be great to have multiple total rows in a table. Say I have a column with the sum in the total row, but I needed the average and count for that column too. The only option I know of now is to make separate calculations below the table. I would be nice if all of those calculations were an integral part of the table.
In addition to Multiple total rows, how about adding SubTotal rows to tables.
SubTotals by itself is nice, but you can't use it in a table. So if you need Subtotals, you can kiss using tables goodbye. I know, I know, you're gonna tell me to use pivot tables for that. And I do. But embedded subtotals would definitely have their use.
I wholeheartedly agree. Having multiple total rows would really expand the already delightful capabilities of tables. I preach and teach Tables to all my coworkers, and this is the only part I find lacking.
In the total row I see 8 options plus a 9th custom option. It would make sense that we would want to use more than one of these. I need at least 4 when I came looking for this answer. Currently, they are just rows below the table. I would like them to be part of the table.
Multiple table total rows would be great. There are many times when I would want bout a Sum, and Average.
It would also be nice if they would enumerate the function values like this.
Instead of =Subtotal(109,Column1)
How about =Subtotal(Sum,Column1)
Additional functions like SumIF and AverageIF would also be helpful.
Jon Wittwer commented
The need for multiple total rows is one of the reasons that I often avoid using Excel Tables, so I definitely like the suggestion of allowing multiple total rows in tables. Right-clicking on the total row and selecting "Table > Insert Total Row" would be a nice way to do it.
Addtion to this post. With tables when you scroll down the headers become the headings, so I would be nice if with totals the headings get more rows on scrolling down.
Kenneth Barber commented
Generalization: allow for multiple rows that contain some sort of information about the whole column, and allow them to be positioned above the table, just below the headers, or at the bottom of the table.
Rob Harvey commented
I was looking for this today - I have a Power Query table linked to multiple data sets which means the table resizes - so I don't want a formula at the bottom which gets overwritten. I wanted a Total - and a custom Total - but you can only have one!