New Column to Running Value

[smilingjohn]

Hi All, I have three columns in my data . Month , C and O .

I want to diplay this information in a table .My requirement is like

I have to show the data from the month of May where C=0 and O is also zero and there should be one more column of

Running to be shown in the table which should calculute the accumulation from previous months (Jan to APR) and carry

forward from MaY , How can i achieve this . I am attaching the QVW file for refrence and the out put should look like below screenshot

Basically it is accumulate calculation

Thanks in advance

[StarinieriG]

Hi,

try to see file attached

[smilingjohn]

Thanks for the reply . 

But this is not as per my requirement . I wanted to ddiplay a chart which has Month, C , O and a new field called Runing . 

and this should start from the MOnth of May . and the Running Field should carry the calculations from previous monhts and start from month May ( Output of Runnig should be added to C abd the total should be subtracted from O and so on ) 

Thanks 

[smilingjohn]

Any Help ?

[Frank_Hartmann · Accepted solution]

Maybe like attached.

hope this helps

[smilingjohn]

Thanks for the  reply Frank_Hartmann

I dont know how you are getting this . 

My formula shoulb be like C-O= Running  for the next month (row ) Running +C - O . 

So when I am considering from the Month of May the C and the O values should remain the same only RUnning must be internaaly doing the calculating and shou;ld produce the result . ( Running total shoul calucute from jan and in the table when i am trying to shwo from may onwards then the output of RUnning should be added to C of May and Get subtracted from O , 

Below is my actual data :

Month	C	O
JAN	1	0
FEB	1	1
MAR	4	3
APR	2	1
MAY	0	0
JUN	8	4
JUL	12	5
AUG	10	4
SEP	5	3
OCT	6	1
NOV	3	4
DEC	8	4

OUt PUT : ( INternally QLikvie shoul calculte the formula from Janaury that is , C-O) 

(If you look into the below table you see the values of C and O are directly coming from the data , but Running column is been calculted  from Janaulry till Aprill ) 

Month	C	O	Running
MAY	0	0	3
JUN	8	4	7
JUL	12	5	14
AUG	10	4	20
SEP	5	3	22
OCT	6	1	27
NOV	3	4	26
DEC	8	4	30

Thanks