Column group A, column group B - how to get Column group A+B?

• dbursey

  Right there with Babe

  Points: 781

  More actions

  May 19, 2017 at 12:56 pm

  #325837

  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!

  Donna