reporting services - Need To Calculate Percentage Difference In ssrs with multiple row and column Grouping -
I have a line and column grouping.
I need the difference and percentage difference of each month as shown below. <:
Example:
march diff 2013 2014 Hyderabad 12 15 15-12 = 3
I want more than this result, I need percentage difference ---- (this year - last year) / last year
I usually try to handle it in SQL and dumb report. In your case, I look at the result like this:
City month month month year Dravid year's feed --------- ---- --- --- ---------------------- Hyderabad 3 March 2013 2013 12 Hyderabad 3 March 2014 2014 15 Hyderabad 3 March 99 99 Diff 3 Hyderabad 3 March 99 99% Diff 0.25
Your Row group will be the city. Your column group 1 group / sorting will be on the monthly integer, and the month displays the string. Your column group will group / sort 2 years / fid integer, and the eardid string will display.
If you provide your SQL, then I can help the result look like this.
If you insist on computing on this report and you have a city, date and value field then your expressions will look something like this:
Diff Calculation You are grouped by City (Row) and Month (column 1) and this is outside the Calc Year (column 2) Grouping and you have added a parameter for @ this user
so that This report can work in future years: = sum (iif (year (field! Date value) = @ this year, fee Value, nothing)) - amount (iif (year (field! Date value) = @ this year 1, field value, value, nothing))
% DIF calculation , with the above assumptions: = (sum (iif (year (field! Date value) = @ this year, field! Value, nothing) - amount (IIF (year! Field! Date value) = @ this year 1, field! Value, value, nothing)) / zodiac (IIF (year (date! Date.value) = @ this year 1, fields! ValueAlu, nothing))
Comments
Post a Comment