Hello - I have a matrix which I have column grouped based on location - now I want to add a couple of columns to the right which will show sums for all locations. "Org" is the Location in the below snapshot. I have this working for each location, but now I want to add a couple of columns to the right which will use the same row grouping, but will aggregate for both locations. I cannot figure out how to do it!
Here's my existing matrix:
And my existing row and column groups:
I feel like it's just a little beyond my reach...a little help, please? Thank you!