There should be a way for users to revise/ edit how grouped columns are calculated when automating ‘totals’ across columns, after toggling ‘totals’ to be on. It still does an automatic sum across grouped columns even though we choose I.e. max/ min / Cartesian product/ etc across rows.
1 Like
Hi,
While I don’t think pivot tables support this functionality as is, you could potentially, with some visual layout changes, make this work.
To clarify, the current setup is something like: You have a pivot table with the values:
Person, count, max
Person_1, 4, 100
Person_2, 8, 120
Person_3, 3, 110
At the bottom, you would like the totals; for count, it would 4+8+3 = 15), but the total for ‘max’ would be the maximum number for for all values (in this case, 120).
If this is the case, my suggestion would be to add a metric card underneath your pivot table & add the several metrics you’d like to total. You’d pass in the object set which you pass into the pivot table then compute & display the metrics you want totaled across the entire set
Hope this makes sense.