how to limit the range of values to sum in a graph

[#1]

hi,

I have this kind of problem:

I have a list of values from 1 to n, i would like to sum or to do a media in a graph not for all values but for a limited range of them,

for example 1+(5% of 1)....and n-(5% of n),

which kind of expression i should use ?

Thanks

[Gysbert_Wassenaar]

You can use the rank function to get the top 10 items. For example, the Sales totals of the top 10 customers:

=aggr(if(rank(total sum(Sales))<=10, Customer),Customer)

Check 'Suppress When Values Is Null' to not show the other Customers.

[#3]

Thanks but the score isn't to have a rank but to have a sum of a list of values excluding a % of them upper and lower,

any idea ?

[#4]

ok,

i have this range of values: 1, 2, 3, 4, 5 in the field named Sales,

i would like to create a graph of the sum of them, but with a different range:

the first value I would like to be 1+5% and the last value I would like to be 5-5%,

so the new range should be: 1.05, 2, 3, 4, 4.75

I hope to have explained better now

[CELAMBARASAN]

Can you upload a sample?

[#6]

you will find here attached my file,

the field is (superficf), i need to do the sum as above with the values of this field,

thanks