Reporting Services 2005 Adding % column to grouped data

• Gillian-1086110

  SSC Enthusiast

  Points: 119

  More actions

  August 13, 2009 at 6:26 am

  #224749

  Hi,

  I have the following matrix showing counts of data grouped by name.

  The total is the 'right-click,subtotal' function of the matrix.

  How do I add a column which displays each group as a %age of the total?

  Codes Count

  Access 2

  Environmental 14

  Local 3

  Other 4

  Owner 24

  Private 5

  Registered 3

  Total 55

• Kites

  Ten Centuries

  Points: 1230

  More actions

  August 20, 2009 at 9:13 am

  #1042193

  You can use the following procedure:

  Lets say the name of the textbox for the total at the end is "TextBox_Total_Value"

  Add the third column for %age of the total

  and enter the expression:

  =100*(Fields!Count.Value / ReportItems!TextBox_Total_Value.Value)

  and your results will be:

  Codes Count %age

  Access 2 3.63

  Environmental 14 25.45

  Local 3 5.45

  Other 4 7.27

  Owner 24 43.63

  Private 5 9.09

  Registered 3 5.45

  Total 55 100