Im working with a tablix in SSRS, but struggling to understand it. I've created two groups that filter out values for [Gained_Cus] for the previous month and the current month. In the last column I want to calculate the variance between these two columns. I have a problem referencing the correct values. How would i do this without referencing each cell individually? The report is too long to do that.
Prev | Current | Variance
[Gained_Cus] | [Gained_Cus] | ?
Thanks