Cumulative value in dimension

[#1]

Hi Team,

How can we sort cumulative value in dimension, I have to find cumulative value of total sales by each salesman and make pie with two levels, one for less than 90 and other for more than 90.

I am using aggr((rangesum(above... but since sales is not sorted at salesman level, I am not able to get correct value, can we sort data in aggr function or some other way?

Regards,

NavdeeP

[sunny_talwar]

Would you be able to share some sample data?

Update: Since you are looking to sort, the only way you can sort a aggr() function is by sorting it in the script because Aggr() function is sorted by the load order.