Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

grouping customers by their sales percentage

Hello everyone,

im having trouble with an expression, the main objective is to count the number of rows in a table that have the same  number(see example above), i dont know if it can be done by some function or by grouping them, the issue here is that  i want to group customers by their  accumulated sales percentage:

example:

Custumers between 0 to 10% =  group 1

Custumers between 10% to 20% =  group 2

... and so.

the grouping cant be done by scripting, its needed to be done in the expression.

I'm leaving  a qvw and excel files with a more detailed example

thanks in advance.

0 Replies