Sum of next colum Divided by total sum of all columns Qlik Script

[noman212]

Hi Folks, 

Please assist how can i achieved this,

i want to make a dimension category  by calculating the scenario given below.

Total = R2 to R7
	Total = R2 to R7 / R2 to R7	100%
	Total /Sum(R3+R4+R5+R6+R7)	90%
	Total /Sum(R4+R5+R6+R7)	80%
	Total /Sum(R5+R6+R7)	70%
	Total /Sum(R6+R7)	60%
	Total /Sum(R7)	50%

I have to calculate this on bases of dimension suppose ID - Retailer

The sample is calculating the value against 1 ID with multiple Retailer.

Please suggest how can i calculate this.

Regards 

[TimvB]

The following expression gives the cumulative percentage of total in descending order:

rangesum(below(sum(FieldName), 0, count(total distinct FieldName))) / sum(Total FieldName)