Posted - 07/01/2014 : 19:42:46
| I have a colunm headers called Endpoint,projection and previous week
I have used something like this to conditional format parts of my report.
=IIf(Fields!EndPoint.Value="Total Sales Division" or Fields!EndPoint.Value="Total End Point" or Fields!EndPoint.Value="Total IP-Relay" or Fields!EndPoint.Value="Total ClearCaptions","CornflowerBlue","Gray" )
Next I want to do some calculations based upon some test data in the previous week column.
EndPoint Projection Prev Week
Inside Sales Account
Plan 36,015 ( needs to be my sum value.
My Anonymous values are empty in my matrix and I would like to fill them via formulas in ssrs.
I need Anonymous Plan to be the sum of House Account Plan and Inside sales account plan. All tree are under my header of endpoint.
in the previous week expression I think I want if endpoint.value="Anonymous Minutes" and Projection='Plan' then Sum(If endpoint.value="house" and Projection.valuje=Plan,sum(previousweek))+ sum(If Endpoint.vaule=INside Sales Account' and Projection.value='Plan,sum(prevoiusweek))
I have not done anything like this before . Can anyone help. And Thanks in advance.