Matrix Totals (Variance instead of Sum)

• carl.meads

  Mr or Mrs. 500

  Points: 519

  More actions

  July 13, 2011 at 6:33 am

  #244040

  Hi There,

  Ive been from pillar to post on this topic now and I'm still no nearer to achieving my goal

  I have a matrix as follows

  Year

  2009 2010

  Asset

  A 45 65

  B 17 10

  C 100 89

  I want to have a variance column on the end so results would be;

  Year

  2009 2010 Var

  Asset

  A 45 65 20

  B 17 10 -7

  C 100 89 -11

  But all I can seem to do is sum them, Ive tried custom code calulated fields and everything I can think of but nothing is working, I'm sure is probably really simple but any help at all will be really appreciated

  Thanks

  Carl.

• carl.meads

  Mr or Mrs. 500

  Points: 519

  More actions

  July 13, 2011 at 7:22 am

  #1352144

  SSRS R2 2008