Forum Discussion
Carlaf
4 years agoFrequent Visitor
Customer's analysis
Good morning, 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. TABLE RANGE: RANGE RANGE_VALUE ...
amitchandak
4 years agoSuper User
Carlaf , Not very clear .
New column in sales
maxx(filter(Range, sales[sales]>= Range[Start Range] && sales[sales]<= Range[End Range] ), Range[Range_value])
or
maxx(filter(Range, sales[sales]>= Range[Start Range] && sales[sales]<= Range[End Range] ), Range[Range])