how to use Cumulative sum in with Aggr()

[#1]

Dear Team,

i want to create a temp table using aggr() method but the Expression should me cumulative sum().

i used below method rangesum(Above(sum({<MEMBER>} TURNOVER),1,rowno())) what we mostly do in table.

i have tried same to within Aggr() function but did not work..

Aggr(rangesum(Above(sum({<MEMBER>} TURNOVER),1,rowno())),CITY,MEMBER)

can any one help me in this

[MK_QSL · Accepted solution]

Copied from Pareto Analysis written by HENRIC

No, unfortunately this is today not possible. But we are looking at possibilities to do this in future versions. Basically, you would need an Aggr() function with a sorted output vector. And today Aggr() cannot be sorted.

[sunny_talwar]

If I am thinking it right, you may need to have RangeSum Above outside the Aggr function. Do you have a sample that you can share?