requirement for query output

Hi Experts,

I have a one requirement where i need to get a column which contains value by which we get after putting cumulative property to key figure. E.g. I have a below output for existing query.

row1col1

ABC 10

AB1 20

AB3 20

AB4 30

But i want to change this output to

row1 col1 col2

ABC 10 10

AB1 20 30

AB3 20 50

AB4 30 80

We can do this by making col2 as a cumulative value, but i don't want this in just for display purpose i want to use this information in Other formula so i want this value available for use in other formula/calculations

Regards,

Ganesh