select first 100 customers within other selection and

[moshe12345]

let say we have a customer model i select only the customer with age 22 

i have 2000 customers in that age range.

now i want to select the first 100 customers with age 22

and late i want to select the next 100 customers with age 22 which are different from the first 100 customers

is there a formula to achieve that ?

may be usintg rank on the customer number or any other field?

i want to use it as formula inside a search object of a object filter

similar to the pic below:

[Javizh]

Hello.

You have some possibilities.

• For the first 100 customers: "= Rank(only({<Age = {22}>}Customer)) <= 100"
• For the 100 to the 200 customers: "= Rank(only({<Age = {22}>}Customer)) <= 200 and Rank(only({<Age = {22}>}Customer)) > 100"

And so on.

If you have the field "Age" filtered, you can remove the set analysis from the search

With the age "22" (or any other year) filtered:

• For the first 100 customers: "=  Rank(only(Customer)) <= 100"

And so on

Note that you can change the function inside the rank to select the first ranked customers in other metrics.

For example

• The first 100 customers, age 22 by sales: "= Rank(sum({<Age = {22}>}Sales)) <= 100"

Example:

Hope it's helpful.

Edited: You dont really need the "Count(...", with the rank function is enough.

Best regards.

[marcus_sommer]

I think more practically as applying such complex search-expression again and again would be to cluster the wanted data with a list-box, for example with something like this:

class(aggr(rank(sum(Sales)), Customer), $(var))

and by using a variable you may also change the cluster-size.