
Re: how to limit the range of values to sum in a graph
Gysbert Wassenaar Oct 30, 2012 10:31 AM (in response to mario marino)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
mario marino Oct 30, 2012 10:41 AM (in response to Gysbert Wassenaar )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
mario marino Oct 30, 2012 10:59 AM (in response to mario marino)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 55%,
so the new range should be: 1.05, 2, 3, 4, 4.75
I hope to have explained better now

Re: how to limit the range of values to sum in a graph
Celambarasan Adhimulam Oct 30, 2012 11:18 AM (in response to mario marino)Can you upload a sample?

Re: how to limit the range of values to sum in a graph
mario marino Oct 30, 2012 11:48 AM (in response to Celambarasan Adhimulam )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

AnalisiSuperfici.qvw 612.5 K




