topic Re: Cumulative value in dimension in QlikView https://community.qlik.com/t5/QlikView/Cumulative-value-in-dimension/m-p/929320#M953099 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some sample data?</P><P></P><P><STRONG>Update:</STRONG> 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.</P></BODY></HTML> Tue, 01 Dec 2015 12:37:23 GMT sunny_talwar 2015-12-01T12:37:23Z Cumulative value in dimension https://community.qlik.com/t5/QlikView/Cumulative-value-in-dimension/m-p/929319#M953098 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>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.</P><P></P><P>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?</P><P></P><P>Regards,</P><P>NavdeeP</P></BODY></HTML> Tue, 01 Dec 2015 12:14:13 GMT https://community.qlik.com/t5/QlikView/Cumulative-value-in-dimension/m-p/929319#M953098 2015-12-01T12:14:13Z Re: Cumulative value in dimension https://community.qlik.com/t5/QlikView/Cumulative-value-in-dimension/m-p/929320#M953099 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some sample data?</P><P></P><P><STRONG>Update:</STRONG> 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.</P></BODY></HTML> Tue, 01 Dec 2015 12:37:23 GMT https://community.qlik.com/t5/QlikView/Cumulative-value-in-dimension/m-p/929320#M953099 sunny_talwar 2015-12-01T12:37:23Z