Finding the difference between a matrix column with different column group values

• stevenplee

  SSCommitted

  Points: 1626

  More actions

  April 10, 2014 at 11:00 am

  #306234

  I am using Report Builder 3.0 and I have create a matrix report that has a column group of Fiscal Year. I have an amount field that will be used provide a total for each year. In this case I am comparing 2013 to 2012.

  What I need to be able to do is to show the difference between 2013.Amount and 2012.Amount.

  Any suggestions.

  Regards

• VA123

  SSCarpal Tunnel

  Points: 4272

  More actions

  April 11, 2014 at 6:16 am

  #1705223

  This link may help: http://social.msdn.microsoft.com/Forums/en-US/65ca2e17-1ca1-4e02-aaac-389442f92cee/get-differance-of-two-columns-in-tablix?forum=sqlreportingservices