Help on selecting values in list making up the top total percentage

%3CLINGO-SUB%20id%3D%22lingo-sub-1475263%22%20slang%3D%22en-US%22%3EHelp%20on%20selecting%20values%20in%20list%20making%20up%20the%20top%20total%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1475263%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20please%20help%20me%20to%20find%20a%20function%20or%20formula%20that%20I%20can%20show%2C%20e.g.%20the%20top%2080%25%20values%20of%20the%20total%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3C%2FP%3E%3CP%3EValue%20list%3A%201%2C7%2C4%2C2%2C5%2C6%2C3%2C8%3C%2FP%3E%3CP%3ETotal%3A%2036%3C%2FP%3E%3CP%3E80%25%3A%2028.8%3C%2FP%3E%3CP%3ETop%2080%25%20values%20should%20be%20make%20up%20by%3A%208%2C7%2C6%2C5%2C4%3C%2FP%3E%3CP%3E(Including%204%20and%20the%20sum%20of%20these%205%20values%20is%2030%20and%20it%20is%2083.33%25%20of%20the%20total)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20percentile%20and%20percentrank%20which%20only%20based%20on%20the%20list%20of%20value%20or%20number%2C%20not%20the%20total.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1475263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485502%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20on%20selecting%20values%20in%20list%20making%20up%20the%20top%20total%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703969%22%20target%3D%22_blank%22%3E%40pc_qci%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20attache%20gives%20a%20possible%20solution%20but%20it%20is%20not%20very%20elegant.%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20what%20you%20are%20trying%20to%20do%20in%20your%20application%20-%20this%20may%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eall%20the%20best.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Can someone please help me to find a function or formula that I can show, e.g. the top 80% values of the total?

 

For example

Value list: 1,7,4,2,5,6,3,8

Total: 36

80%: 28.8

Top 80% values should be make up by: 8,7,6,5,4

(Including 4 and the sum of these 5 values is 30 and it is 83.33% of the total)

 

I tried percentile and percentrank which only based on the list of value or number, not the total.

1 Reply

@pc_qci 

 

Hi 

 

The attache gives a possible solution but it is not very elegant.

I am not sure what you are trying to do in your application - this may help!

 

all the best.

 

Peter