Greetings,
I'm really enjoying the Pivot Tables to build out insight. I do have a few questions on behavior and how to go about enabling/disabling various Subtotals/Grand Totals. I've toggled them in the UI but it appears to be an all or nothing. Toggling Total on each dimension (and the Total) would be handy.
I deal with data sets that use volumes of different units and my Subtotals work well for summarizing each category very well however the Grand Total performs simple aggregation regardless of unit and therefore meaningless. Is there a mechanism to enable/disable visualizing the Grand Total but retain the Subtotals (..and presumably vice versa)
I've attempted to create a custom column to create a normalized volume (which works fine) but I lose the fidelity of the individual product volumes which I'd like to retain as this is is what we see on reports.
We worked around this by having multiple questions on a dashboard. Each question shows a different granularity of the same data.
Not ideal but good enough until it's improved in Metabase (it's developing so quickly, something will be along at some point).
If you want to help things along, get over to Github and make the suggestion.
Thank you Andrew, great feedback. Yes, I decided to do that and I went ahead and found a thread and added to it on Github. This thread below seemed to adequately capture the objective. At the moment its not a huge issue (i flagged a Text item to warn users)
Configure pivot table column rollup, column subtotals, and column grand totals separately #56527