1 Reply Latest reply: Sep 6, 2018 12:48 PM by Quy Nguyen RSS

    How to create calculated fields by using existing fields?

    VAIBHAV JAIN

      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?

        • Re: How to create calculated fields by using existing fields?
          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')))