Edit the subtotal region in a matrix-SSRS 2005

• fareedhmohamed

  Ten Centuries

  Points: 1035

  More actions

  June 16, 2015 at 4:00 am

  #309278

  Hello All,

  I have been stuck with this problem for a week. I seem to be getting nowhere. ANy help would be appriciated.

  Curretnly below is how my matrix looks like

  jan Feb Mar April ..... Total

  item1 1 1 1 1 ...... 4

  item2 4 .............................

  item3 5 ..........................

  item4 6

  Total 16 ............................

  I would like to be able to do an average on Total. Is that possible. There has been several articles which I have followed but I am sooo confusedddd. Can someone helppp?

  Thanks

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  June 17, 2015 at 4:27 pm

  #1806236

  Maybe this article[/url] will help.

  Or maybe use this to get the average?

  COUNT(Fields!enrollmentID.Value)/CountDistinct(Fields!EnrollMonth.Value)

  I added it to a new column outside the normal matrix group