Cumulative sum that resets after each value of customer

[ali_hijazi]

Hello

I'm working on QlikView 12

I have a pivot table as follows:

when I'm displaying more than one customer then the cumulative sum continues I want to start for example here for the second customer with -1,789.45 instead of 1902.67 which comes from 3,692.12 of the first customer added to -1,789.45

the expression for the open amount is

sum({<accounting_document_status={'open'}>}accounting_open_amount)

the expression for the cumulative amount is:

[Open Amt] + RangeSum(Above(Total [Open Amt],1,RowNo(TOTAL)))

it works fine when there is only one customer displayed

[sunny_talwar]

May be remove the 2 TOTALS from the expression

[Open Amt] + RangeSum(Above([Open Amt],1,RowNo()))

[sunny_talwar]

Actually this might not work because you have many dimensions in your chart.... you might need an Aggr() function... but it might be easier if you can share a sample and we can try it out

[ali_hijazi]

check attached sample document please

[sunny_talwar]

If you have qv 12, you can try this

Sum(Aggr(RangeSum(Above(Sum({<accounting_document_status={'open'}>}accounting_open_amount), 0, RowNo())), customer_name, (document_number, (numeric))))

[antoniotiman]

Hi,

Try

RangeSum(Top([Open Amt],1,RowNo()))

Regards,

Antonio

[sunny_talwar]

Check this link out

The sortable Aggr function is finally here!

[ali_hijazi]

it didn't work for the rest of the customers

Please check my new post titled Help in Sortable Aggr