percentage calculation in matrix in ssrs
September 27th, 2012 5:25am

HI I am having a matrix report in ssrs 2008 r2, like this in the in the above report the 3 columns 2002,2003,2004 are there in fiscalyear column. i need (2003-2002 ) sales percentage how can i do this. any information will be helpful. Nagaraj
September 30th, 2012 8:33am

Most often a Fiscal year starts on a specific day of the week so it usually doesn't start on the 1st of the month. One year it is June 3, The next May 30. Without embedding it in your data source from a reliable source, the best I can suggest is to get close. If your fiscal year is around the start of June each year (June 2012 is FY2013) then you can get the fiscal year with: =Year(DateAdd(DateInterval.Month,7,Fields!CalendarDate))
September 30th, 2012 8:42am

You may be able to use RunningValue for this. To get % Sales what are you considering the total? Is it Sum(Sales in Target Years)/Sum(Sales in All Years)?
September 30th, 2012 9:54am

Hi Nagaraju- Assuming you are trying to get 2002-2003 sales as a percentage of total sales, you can try the following: 1) In design view, right click [Sum(Sales)] 2) Go to "Add Total" and add a column total 3) Right click in the newly created column total field and choose "Expression" 4) In the expression window type =sum(iif(Fields!FiscalYear.Value <> 2004, (Fields!Sales.Value), 0))/sum(Fields!Sales.Value) Hope this helps~Bonediggler
September 30th, 2012 11:44am

Hi bonediggler, Thanks for replying, i want to know the increase percentage in sales from 2002 to 2003 and 2003 to 2004, it is displaying as fiscalyear column group, how can i take particular columns(2002 sales, 2003 sales) in the expression.Nagaraj