How to create calculated fields by using existing fields?

[Anonymous]

How can I segregate the sales user by zone?

Example:  If I have a filed namely "Sales User Name" & it contains 8 users (2 users each zone North, South, East, West).  Then How can I create a new filed "Zone" by using the Sales User Name field?

[Quy_Nguyen]

Hi,

The easiest way to achieve this is create a calculated dimension by using if command.

Exp:

Assmed you have User1 and User2 belong to Zone A, User3 and User4 belong to Zone B, User5 and User6 belong to Zone C,User7 and User8 belong to Zone D. Write for your dimension in chart:

If(Match("Sales User Name",'User1','User2'), 'Zone A',
If(Match("Sales User Name",'User3','User4'), 'Zone B',
If(Match("Sales User Name",'User5','User6'), 'Zone C', 'Zone D')))