I have SP which returns Companyname, years, sales columns
CompanyA 2005, 1000
CompanyA 2006 100
CompanyA 2007 500
Like wise for 10 different companies and 4 different years.
I am using matrix in SSRS to show the data.
I need to show data like this
Company Name 2006 2007 2008 [sales percentage increase(06-07)] [sales percentage increase(07-08)]
So i need to get value from the previous column group and do the calculations.