Need to group customers based on

Question

How to dynamically keep groups that would change as per profit? i.e, if profit is below 10% of total, then group1 if profit>20% then group3 else group2.

Answer 1

Hi Karthick, You calculative field to form dynamic groups.

Create a calculative group as

IF [Profit%]<10% THEN "Group1"

ElSEIF  [Profit%]>20% THEN "Group3"

ELSE "Group2"

END

The above calculative field would create groups as per profit% and add fields in respective groups. The groups created by calculative groups are dynamic.

Hope it helps.