Customer's analysis

Question

Good morning,&nbsp;i've got a list of seller's and customer's.I would like to define the range of a customer's for seller's.&nbsp;TABLE RANGE:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANGE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANGE_VALUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50000-70000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30000-49999&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp;SALES:SELLER&nbsp; &nbsp; CUSTOMER'S&nbsp; &nbsp;SALES&nbsp; &nbsp; &nbsp; &nbsp; RANGE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANGE_VALUETom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jerry&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50000 - 70000Tom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mary&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 - 200&nbsp;&nbsp;Thanks

amitchandak · Answer

Carlaf , Not very clear .
&nbsp;
New column in sales
&nbsp;
maxx(filter(Range, sales[sales]&gt;= Range[Start Range] &amp;&amp; sales[sales]&lt;= Range[End Range] ), Range[Range_value])
&nbsp;
or
&nbsp;
maxx(filter(Range, sales[sales]&gt;= Range[Start Range] &amp;&amp; sales[sales]&lt;= Range[End Range] ), Range[Range])

Forum Discussion

Customer's analysis

1 Reply

Related content

Cohort analysis

Customer Churn Analysis

Retention analysis

Customer cohort analysis

Customer Satisfaction Analysis