Running Value in Reporting

See more:

reporting-services

reporting

Hi EveryBody,

I'm currently doing Report Server concept.
Now, i have a 3 columns like material_Quantity, Category_Name & Rev.

Upto now what i'm doing is for Rev wise , for same category what are the materila's having and what are the quantity for those material's i'm displaying upto now.

EX:

                      Rev0                                  Rev1
         category1          category2
qty1    qty2    qty3       qty1  qty2  qty3

Expression for Quantity Column is

=SUM(Fields!Material_Quantity.Value)

Now, what is question is for Rev0 ,Category1,qty1 is 2.5. and Rev1,category1,qty1 is 1.5. Now i want to display the Running value.

Ex:

In Rev1,Category1,qty1 i want to display 2.5+1.5=4.

How to do this for this i'm using RunningValue concept buti'm not getting the whatever i'm expecting ...

Please help me how to resolve this issue....