Hi Phil- No it doesn’t do that and I’m not sure if I’d want it to do that in my case because if a user removes the ‘currency’ column grouping the data would add $500K CAD + $500K USD and display $1 M. So that data should get filtered before displaying it/removing groupings. I’m sure there’s other cases where it would be useful to use that & I do like the flexibility of expandable rows.
What I think it needs is a filter option to only show the columns by selected currency with a filter- only display ‘USD’ or only display values after today. It would be nice if users could do that on Pivot Tables like we can on Object Tables.