Dynamic parameter that populates a column, and changes it's value based on customers/clients

Hi Anonymous ,

According to your needs, if you want to continue to classify customers based on numbers and continue the subsequent operations, you can use the Rank function to sort them in descending order. The largest number indicates the greater the importance of the customer. For further processing, you can use the if function.

like this: 

M = if(number meet the condition,A,B)

If you still can’t solve it, can you provide the expected results and test data, so I will answer you as soon as possible. Let me know immediately and looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.