I am using SSRS 2008-r2. I have a few matrix's in my report, each has its own dataset. I need to be able to use the total value from the previous column as the starting value of the next column and that starting value would then be used in the calculation to find the total in that column. Example picture below:
In the Ending Position Cell the expression would be (Starting Position+NewMembers-Cancelled/Resignedmembers-Lapsed) to give the value. The picture example shows the Ending position as 439 which then needs to be used as the starting position for the following month. My Matrix set up is:
The closest question I have found is here but I have not been able to get it to work: how-to-get-the-previous-value-of-a-row-in-ssrs I had a read up on using the lookupset function mentioned in the question but I do not have fields in my datasets for the starting and ending positions. Is there a way to do this in the matrix? or do I need a separate totals dataset that I use to pull the values into this matrix.
Thanks in advance.
I guess the more simple and straightforward solution is to calculate and include those values as fields in your dataset.
PS It looks like you already have a start and end field in your dataset (BegBal, EndBal)?