How to do Group Total and Group Average in the Matrix in SSRS 2008R2
Hello, I am using Matrix in SSRS 2008 R2. In the Matrix, in the "Row" cell, i did put "Category"field, in the "Column" cell, i did put "Description" filed and in the "Data"cell, i did put "Details" field. Under the "Category" field there are three categories, which are "Avg Consumption", "Total Consumption per month", and "Total expenditures" respectively. For the "Avg Consumption", i need "Row Average" at the last cell in the row and for the "Total Consumption per month", and "Total expenditures" i need total of the row in the last cell of the row. If i want to do "Row Total", i would do by selecting "Add Total" and then "Row". But, here my problem is bit different, that, "Avg" of the row, which must display at the end of the "Cell" for the "Avg Consumption" category , and "Total Consumption per month", and "Total expenditures", "total" of the row must display at the end of the "Cell". Kindly please help me by providing suitable solution, you would be much appreciated. Thanks in advance.
April 26th, 2011 1:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics