Can aggregate values be shown as group footers?

Get Help
1

I’m surprised this isn’t a FAQ, but I was unable to find anything…

Can Table views have summary values after each group’s data? This would be an alternative to true “grouping” mode… show all data rows/columns in the group, then the summary value, as opposed to a single line with the group-by value and the summary value.

I know what I’m asking is more relevant to a report writer than a BI tool… but the product is already awesomely close to that! Basically, that one feature would save me from having lots of spreadsheets and/or a report writing tool.

Thanks for fabulous product you guys!

2

Hi @tengammaps
There’s currently not a subtotal/summary out-of-the-box. You would manually have to do things like writing it in SQL.
It sounds a lot like some of these requests - upvote by clicking :+1: on the first post of each:
https://github.com/metabase/metabase/issues/3218
https://github.com/metabase/metabase/issues/5308
https://github.com/metabase/metabase/issues/7521
https://github.com/metabase/metabase/issues/8572

3

Thanks flamber. I knew I couldn’t be the only person to request something like this :slight_smile: