Skip to Content
0
Former Member
Jul 01, 2016 at 09:03 PM

How to group records in Bex Query Designer

689 Views

Hi all, I am new to Bex.

In Bex designer, i want to group Customer in to Groups.

Ex:

Customer Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Customer 6 Customer 7 Customer 8

Condition:

If (Customer = "Customer 1" or "Customer 2") then "Group A" else if(Customer = "Customer 3" or "Customer 4") then "Group B" else "Group C"

How can i achieve this in Bex Designer???

Thanks.

Kumar