accumulated Sum

[rohit214]

Hi All,

I have a table and i want the result shown below

Data Table

Required Output

Thanks

Rohit

[MK_QSL · Accepted solution]

Create a straight Table

Dimension = Bucket

Expression

SUM(No.)

and

SUM({1}TOTAL No.)-RangeSum(ABOVE(SUM(No.),1,RowNo()))

Hope this helps...

UPDATE:

There is another option..

RangeSum(Below(SUM(No.),0,Max(TOTAL Aggr(RowNo(),Bucket))))

[brijesh1991]

PFA qvw

[kangaroomac]

Hiya,

If you would like to add the other field (No.) as well, you'll have to do it in the expression (with no aggregation), not as a dimension (else the first value 347 will be copied all the way down).

I've attached a QV Sample.

[#5]

I can not see your input data, but what do you think about using Accumulation property? (Properties/Expression tab - under expression list).

regards

Darek

[rohit214]

Thanks to all

Regards

Rohit