cumulative sum by customer

[ali_hijazi]

Hello got the following pivot table with dimensions(Customer, Customer Rout, Invoice, Invoice date, and invoice due date

I want to calculate the cumulative sum of invoices by customer

I tried the following expression:

$(vOpenInvoice_NetAmt) + RangeSum(Above(TOTAL $(vOpenInvoice_NetAmt),1,RowNo(TOTAL)))

yet this works fine only if I select one customer with multiple customers the amount is accumulation is full

is there another approach or I should replace rowno(total) with something else? as RowNo(Total) ignores all dimensions

[sunny_talwar]

Your chart is still sorted by this?

Only({1<TrxType={'sales','sales returns'}, DocStatus={'O'},TrxDate=,DAY=,MONTH=,MONTH_NUM=,MONTH_YEAR=,YEAR=,QUARTER=,CusName=$::CusName,CustomerCode=$::CustomerCode,TrxDefaultSaleman1=$::TrxDefaultSaleman1,TrxDefaultSaleman2=$::TrxDefaultSaleman2,TrxDefaultSaleman3=$::TrxDefaultSaleman3>}DocDueDate)

[ali_hijazi]

yes

[sunny_talwar]

It would be difficult to know without looking at this...

[ali_hijazi]

well I managed to make it work but the response on the report is extremely slow

please advise

[sunny_talwar]

How did you do it? Without knowing what you did, I won't be able to offer any advice

[ali_hijazi]

ok I will share with you a reduced document just give me around 5 minutes

[ali_hijazi]

please check updated docuemnt attached

for this customer the Cum Amt is taking about 2.5 minutes

and I just noticed that for this particular customer the formula is not giving correct results