June 1, 2013 at 12:17 am
HI ,
I was wondering if someone could help me.
I have a SQL table with the following fields:
-Variable
-Period
-Value
which generates the following simple tablix (matrix:
Period1 Period2Period3
Var1101520
Var2124
Var3100200150
Var4100011001120
Var5505560
based on 5 variables and 3 periods.
However I also want to show some calculations based on some of the variables.
Say I also want to show Var1 x Var4 and Var1 x Var5.
I want to generate the following:
Period1 Period2Period3
Var1101520
Var2124
Var3100200150
Var4100011001120
Var5505560
VarN
Calc Var1 x Var4100001650022400
Calc Var1 x Var55008251200
Avg (Var 1-5)232.2274.4270.8
I've tried using Sum(IIF(Fields!Variable.Value = "Var1", Fields!Value.Value,0)) x Sum(IIF(Fields!Variable.Value = "Var4", Fields!Value.Value,0))
but its not working for me. I've tried the InScope function but cant get it working. Should I be creating a crosstab dataset rather than trying to do the calculation in the matrix
Any help would be really appreciated. (SRS 2008 R2)
June 10, 2013 at 5:20 pm
Why don't you just use Excel?
Period1Period2Period3
V1101520
V2124
V3100200150
V4100011001120
V5505560
V1V4100001650022400
V1V55008251200
etc...
So much simpler takes 10 sec or less.
Unless...
tryi
there is some huge data you are trying to report upon.
June 11, 2013 at 5:21 am
Try putting all calculations in rows outside of your row groups, "Insert Row" --> "Outside Group - Below". Works fine for me. Check out attached rdl.
June 11, 2013 at 5:35 am
That was really helpful,
Many thanks for taking the time out to respond.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply