How to Add % change or Growth Rate columns to Matrix Control

• b_rajeshwari

  SSC Rookie

  Points: 39

  More actions

  December 5, 2008 at 9:12 am

  #196872

  data from a database in this format:

  Code Year Amount

  A 2003 100

  A 2004 120

  A 2005 99

  I display the data in a Matrix control like this:

  Code 2003 2004 2005

  A 100 120 99

  B 99 80 110

  Code 2003 2004 2005 Gr 03-04 Gr 04-05

  A 100 120 99

  B 99 80 110

  I want to add a Growth Rate column to the Matrix control to show the Growth Rate bewtween years 2007 and 2008, like show below:

  How do I do it

• Niraj-627298

  Hall of Fame

  Points: 3641

  More actions

  December 18, 2008 at 4:31 am

  #914394

  Hi Rajeshwari...

  Sorry...I tried to work around your issue..But unable to get this done with Matrix Report Layout...

  I guess..you posted this issue long days back..So...if you have come across any solution for the same..please let me knw..too...

  Thanks,

  Niraj

• b_rajeshwari

  SSC Rookie

  Points: 39

  More actions

  April 16, 2009 at 8:01 am

  #978853

  So far I am successful with this attempt

  I have now tried creating the growth rate columns in SQL Query itself

  Select d.id,d.Code,d.Year,d.Value,d.Value-q.Value as Diff, (d.Value-q.Value)*100/q.Value as GRRate

  from Table d

  Left join (Select d1.id,d1.Year, d1.Value

  From Table d1

  ) as Q

  on Q.id=d.id and d.year=q.year+1

  order by Code

  I have added 2 matrix controls

  In first Matrix control I have added all necessary fileds and Value Columns

  In second Matrix control I have also added all those fields but kept them visible=false and then added Grwoth Rate column

  This works fine if I do not have expand collapse feature on my rerpot

  I am right now not able to controls 1 matrix control with other

  Any help is appreciated

  Thanks