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...

[ali_hijazi]

if I sort by invoice date then documents with the same date will have zero as cumulative amount

please advise

[ali_hijazi]

how can I sort first by date and then by doc number in the structured parameters?

[sunny_talwar]

May be create a new field in the script using the combination of Invoice Date and Doc No. Something like this

Floor([Due Date]) + [Doc No.]/1E10 as NewField

and then use NewField in your Aggr() function