Prev: SSRS Advance Services and passing parameters via <form>
Next: Sum Totals on Conditional field
From: Jeff on 30 Nov 2009 14:31
I am somewhat new to SSRS, and trying to do something that seems like it
should be easy. I have two rows of data that are displayed in a tablix and
I need to calculate the % variance.
This is the tablix: tablix.jpg

This is what the report currently looks like: report.jpg

I want to calculate for each month (Forecast - Actual) / Forecast. But in
the tablix, there is only one datafield. Is there some way to address row 1
and row 2 at runtime for the calculation?

Any help is appreciated.

-Jeff





 | 
Pages: 1
Prev: SSRS Advance Services and passing parameters via <form>
Next: Sum Totals on Conditional field