This seems like it should be easy. I have a matrix control that I am trying to subtotal a column in a rowgroup. I've clicked on the leftmost entry of the rowgroup and selected 'subtotal' which adds a 'Total' row and tried the same for the column header which adds a Total for the column. But when I run the report the subtotals only include the first entry or sometimes I get a random entry in each row (row subtotal) or column (column subtotal), but never a true subtotal for the column or row. Why won't it add all of the cells together?
I found one posting that suggested I needed to wrap the detail in the cell with SUM(detail.value). Unfortunately, this just puts the Grand Total for that value in every cell of the matrix.
I see a number of postings of people struggling with this. How do I get each column to subtotal properly? Is it a known bug and I need to apply a patch or something, because it seems like a bug?
Any workable solution that prevents me from having to rewrite my stored proc or redo the whole report using a table control instead of a matrix would be most appreciated.