none
Hierarchical Grouping in a Matrix RRS feed

  • Question

  • I have a matrix. I have categories across the top, and locations down the side. So far so good. Problem is, "locations" are hierarchical. Meaning I have "North America" then "Canada" then "US" then "New York", etc. Easy enough, I set the "Parent Group" property and it's fine. Here's the problem though, I need subtotals along the way. I can't find a way to do that. Here is a sample of the output I want:
                                  Cat1     Cat2     Cat3
    N. Amer.                     
      Canada
        AB                           1          1          1
        BC                           1          3          4
        MB                           2          1          3
        CA TOTAL                     4          5          8
      US
        CA                           1          2          3
        NJ                           2          1          1
        NY                           1          1          1
        US TOTAL                     4          4          5
      N. AMER TOTAL                  8          9          13
    I can't, however, find a way to insert the totaling the way I want. I have my "N. AMER TOTAL" by simply inserting a "subtotal" field onto my matrix, but how can I add the subtotals at each "grouping" in the hierarchical data? Is this even possible? It seems like something that must be fairly common...

    Thanks!
    Wednesday, June 10, 2009 7:19 PM