August 27, 2009 at 5:14 am
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
August 31, 2009 at 8:19 am
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)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply