Segment customers in levels

[ecolomer]

I have an table with sales to customers and the area where the sale occurs.

There are customers who may be in more than one area.

Levels: T1 and T2 are defined by user

I would analyze those sales by three levels:

- Customers in an area whose sales are less than a user-defined value (T1)

- Customers whose sales are between T1 and T2

- Customers whose sales are higher than T2

For each tranche would like to know the number of customers, sales, average selling each zone.

Attached basic example with Excel file and QV

Thank's in advance

[swuehl]

Maybe like attached?

[ecolomer]

Thank's, but I can't touche the script

Any idea?

[maxgro]

maybe, for T1

Count(distinct if(aggr(sum(Venta), Cliente,Zona)<$(T1), Cliente))

sum(if(aggr(sum(Venta), Cliente,Zona)<$(T1), Venta))

[swuehl · Accepted solution]

Similar idea like maxgro.

Count( DISTINCT Aggr( if(Sum(Venta)<$(T1), Cliente), Zona, Cliente))

Sum( Aggr( if(Sum(Venta)<$(T1), Sum(Venta)), Zona, Cliente))

Latter should also work with more than one Venta record per Cliente and Zona.

[ecolomer]

Thank's

[ecolomer]

Thank's