https://community.qlik.com/t5/QlikView/How-to-compute-exclusive-with-out-using-Row/m-p/554603#M207197 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>From HIC blog have show us the inclusive % using below expression :-</P><P></P><P>RangeSum(Above(Sum(sales), 0, RowNo())) / Sum(total sales)</P><P></P><P>I need to replace with , because if using row , it will not allow me sort sales col from hi to lo:-</P><P></P><P>Sum(sales)/Sum(TOTAL(sales))</P><P></P><P>For Exclusive % using below expression :-</P><P></P><P>RangeSum(Above(Sum(sales), 1, RowNo())) / Sum(total sales) </P><P></P><P>I like to ask , how to replace the above with out using row ?</P><P></P><P>Paul</P></BODY></HTML> Tue, 10 Dec 2013 22:30:59 GMT 2013-12-10T22:30:59Z https://community.qlik.com/t5/QlikView/How-to-compute-exclusive-with-out-using-Row/m-p/554603#M207197 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>From HIC blog have show us the inclusive % using below expression :-</P><P></P><P>RangeSum(Above(Sum(sales), 0, RowNo())) / Sum(total sales)</P><P></P><P>I need to replace with , because if using row , it will not allow me sort sales col from hi to lo:-</P><P></P><P>Sum(sales)/Sum(TOTAL(sales))</P><P></P><P>For Exclusive % using below expression :-</P><P></P><P>RangeSum(Above(Sum(sales), 1, RowNo())) / Sum(total sales) </P><P></P><P>I like to ask , how to replace the above with out using row ?</P><P></P><P>Paul</P></BODY></HTML> Tue, 10 Dec 2013 22:30:59 GMT https://community.qlik.com/t5/QlikView/How-to-compute-exclusive-with-out-using-Row/m-p/554603#M207197 2013-12-10T22:30:59Z