Hello,

Here is my data on the excel file. On the YoY Increase row I have the following formula:

=C5/B5-1

=(1,184,232.41/1,755,273.35)-1

=48.2%

My question is I want to add the formula in my expression below but I am having difficulty doing it. Basically, I am using tablix. YEAR_PAID is the column_group and I have to sum the paid_amount based on the paid year. To compute the YoY Increase I have to do the following formula above. How will I'm going to that in SSRS.?? 

TIA.

Hi MarNipz,

You can follow the below steps to add the growth column:

Here is the sample data I used:

Country Year  Amount

SH      2013  429659007.00

SH      2014  445416499.00

WX      2013  35319125.00

WX      2014  33483201.00

SZ      2013  3373345.00

SZ      2014  5334839.00

1. Insert a Matrix, add a Country to row, Year to Columns and Amount to Data.

2. To calculate the growth%, insert a column out of the group and use the expression like:

=(LAST(Fields!Amount.Value)-FIRST(Fields!Amount.Value))/LAST(Fields!Amount.Value)

3. Right-click Parameter folder to add a Year parameter and specify values. Do not add a parameter in the dataset. Right-click Year group > Group Properties > Visibility. Choose Show or hide base on an expression.

Use expression:

=iif(instr(join(Parameters!Year.Value,","),Fields!Year.Value)=0 ,true,false)

Here is the result:

Hi,

Just found out an answer!

select x.YEAR_PAID, x.PAID_AMT/prev.PAID_AMT-1 as YOY

from tbl_Paid_Amounts as  x

left join tbl_Paid_Amounts as prev 
on x.YEAR_PAID = prev.YEAR_PAID+1

Thanks for the suggestion.

• Marked as answer by MarNipz 8 hours 17 minutes ago