How to write set expression for the below scenario

[#1]

Hi ,

Below is the sample data(input data) and I want to achieve (expected output).

Actually I want to do the 'cumulative sum'(running total) of 'hrs' column. and show the data as below.

e.g. for 3may team a has woked 20hrs on task 1 and on 4may 20hrs on task1. so for 4th may it should show 40hrs for task 1 by team a.

Can anyone suggest something???

[migueldelval]

Hi Kulwant,

Check please this example,

Regards

Miguel del Valle de Gracia

[#3]

there is nothing in your qvw. there is only one inline is loaded no charts are there. I wanted to show the output in straight table.

[migueldelval]

Sorry Kulwant,

Try it now

Regards

Miguel del Valle

[#5]

Hi,

I want to running sum of the highlighted vales. you are doing it for different task no. I want it for same taskno

[migueldelval]

Hi Kulwant,

Try to use Total after Above in set analysis.

Regards

Miguel del Valle