Ok so I have read the article and also did try to explain which can help me to get the solution:

I have a table :

CREATE table Statistics

(

Status Varchar(10),

Opco Varchar(30),

Region Varchar(30),

Country Varchar(30)

Jan Decimal(3,2),

Feb Decimal(3,2),

Mar Decimal(3,2),

…….

…….

…….

)

Inserting data into the table:

Insert into Statistics

(

‘Absolute total’,

‘OPCO1’,

‘EMEA’,

‘GB’,

‘0.3’,

‘1.3’,

‘0.7’

)

Out put I require is the second row calculating the cumulative totals as shown below:

Absolute total OPCO1 EMEAGB0.3 1.3 0.7

Cumulative total OPCO1 EMEAGB0.3 1.6 2.3