Help in sortable Aggr

[ali_hijazi]

Hello got a pivot table showing the open amount for each customer

and in another column I want to show the cumulative amount

the cumulative amount I'm using Aggr with sorting but it is not working properly

check attached document and advise please

as the cumulative amount should start with 82.5 and so on...

[Frank_Hartmann]

which QV Version are you using?

The sortable Aggr function is finally here!

[ali_hijazi]

I'm using qlikview 12

[Anil_Babu_Samineni]

Is this you are expecting on your chart?

[ali_hijazi]

check attached document and help please

[sunny_talwar]

I'm using Aggr with sorting but it is not working properly

You have neither explained what isn't working in your post, nor have you mentioned anything in the attached qvw. What is not working properly? You need to point it out, else we will just be doing a lot of guess work

[Anil_Babu_Samineni]

I've checked and i gave some inputs. Are you looking for that? Or you may need to show where it is not working as sunny suggested.

[ali_hijazi]

the cumulative amount is not working properly

see in the screen shot and the document attached

the cumulative amount should start with 82.5

[ali_hijazi]

the cumulative amt should start witn 82.5

so there is something wrong in the Aggr function's structure parameter that I'm supplying

Please advise

[sunny_talwar]

Since you are sorting by accounting_document_number, here is the sort order

17000010 is 1 followed by 17000011 followed by 17000198 and so on...