Add a Grand Total Percent to Matrix

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  August 27, 2009 at 5:14 am

  #204101

  I have a matrix which shows me grand totals (i.e. sum), I would like to add a line beneath the totals that allows me to show the grand total as a % of the overall total.

  I know that the matrix function in SSRS is an absolute living hell but wondered if anybody out there might have come across a solution to this. At the moment I am creating a complete new matrix just to provide these values, which is a fairly rubbish solution to the problem.

  Any help very much appreciated.

  Nigel.

  Nigel West
  UK

• Kites

  Ten Centuries

  Points: 1230

  More actions

  August 31, 2009 at 8:19 am

  #1046884

  If you can get the Total of all the Values(Overall Total) put it in box and then the grand totals for the rows/columns in a separate row/column. then in the percentage row write the expression to get the percent values...

  =100 * ReportItems!GrandTotal.Value / ReportItems!OverallTotal.Value

  and hide the text boxes whichever you don't need to display(Eg.OverallTotal)