views:

224

answers:

0

I'm trying to show a tablix of data where the result of a sum changes in each row. I have the rows grouped by date and sorted in descending order such that the most recent date is first. What I want to do is compare each row's sum with the sum of the previous row, e.g.

Date        Sum  PrevValue
----------  ---  --------------
2009-09-28  3    2
2009-09-27  2    1
2009-09-26  1    5
2009-09-25  5    ...
...

I found the Previous function and thought this would be useful, but since I'm displaying my data in descending order, I get results like this:

Date        Sum  PrevValue
----------  ---  --------------
2009-09-28  3    
2009-09-27  2    3
2009-09-26  1    2
2009-09-25  5    1
...

The expression I'm using is =Previous(Sum(Fields!Sum.Value, "MyRowGroup")). I checked but there is no "Next" function to go along with Previous. How might I get the aggregate data I'm looking for while keeping my tablix sorted in descending order?