5 Replies Latest reply: Oct 30, 2012 11:48 AM by mario marino

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

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

• ###### Re: how to limit the range of values to sum in a graph

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.

• ###### Re: how to limit the range of values to sum in a graph

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 ?

• ###### Re: how to limit the range of values to sum in a graph

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