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