Matrix Report Row Group Level Calculation

• raghavag7

  SSC Veteran

  Points: 203

  More actions

  October 16, 2014 at 12:21 am

  #312298

  i have one Matrix Report ,

  April May June

  2001 10000 2000 30000

  2002 0 0 1000

  2003 10 0 2000

  in this matrix report i want calculate row group level 2003 = 2003-2002.

  How to write Expression ?

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  October 16, 2014 at 2:09 am

  #1752757

  SELECT [row group level 2003 April] = [2003].April -[2002].April

  FROM [Matrix Report] AS [2003]

  JOIN [Matrix Report] AS [2002] ON [2003].[Unnamedcol] = 2003 AND [2002].[Unnamedcol] = [2003].[Unnamedcol] -1

  If i got it right.