Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to change the first bucket the the class function? For example, I would like it to show 0-10 for the first bucket and then increments of 30 after ( 10 - 30, 30-60 , 60-90...etc) .
Example:
Buckets | count person |
0 - 10 | 1 |
10 - 30 | 2 |
30 - 60 | 5 |
60 - 90 | 1 |
I have attached a file with sample data if it is possible.
Thanks,
Ash
maybe with an additional if
=if(aggr(Class(Sum(Sales),2),SalesPerson)<10, aggr(Class(Sum(Sales),10),SalesPerson), aggr(Class(Sum(Sales),2),SalesPerson))
Thanks, that gets me close.