3 Replies Latest reply on Mar 30, 2017 4:57 PM by Craig Dewar

    how to recreate names

    Alex Martino

      I have two categories in a dimension called categories.

       

      Categories has Real Estate and Renewals.

       

      Then there are subcategories.

       

      Real Estate = Real Estate and Other

      Renewals = Real Estate, Consumer, and Other

       

      I want to create a new dimension called channels with the following logic.

       

      If category = Real Estate, then CHANNEL = Real Estate (regardless of subcategories)

      For Renewals, I want each of the subcategories to be titled Renewals. So Real Estate Renewals, Consumer Renewals, and Other Renewals.

       

      How can I create this?

       

      Thanks!!

        • 1. Re: how to recreate names
          Chris McClellan

          Some sample data would be great, in an Excel file would be even better

          • 2. Re: how to recreate names
            Sujay Paranjpe

            Hi Alex,

             

            I am guessing this is what you have.

              

            CategorySubcateogry
            Real EstateReal Estate
            Real EstateOther
            RenewalsReal Estate
            RenewalsConsumer
            RenewalsOther

             

            and this is what you need

             

            Channel
            Real Estate
            Real Estate Renewals
            Consumer Renewals
            Other Renewals

             

            Use the below.

             

            Create calculated field

            [Channel]

             

            IF [Category] = "Real Estate"  THEN

                "Real Estate"

            ELSEIF [Category] = "Renewals" AND  [Subcateogry] = "Consumer" THEN    

                "Consumer Renewals"

            ELSEIF [Category] = "Renewals" AND  [Subcateogry] = "Real Estate" THEN    

                "Reals Estate Renewals"

            ELSEIF [Category] = "Renewals" AND  [Subcateogry] = "Other" THEN    

                "Other Renewals"

            END

             

            Best,

            Sujay

            If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

            1 of 1 people found this helpful
            • 3. Re: how to recreate names
              Craig Dewar

              Sounds like you are almost there Alex.

               

              Have you tried a simple calc like the following?

               

              channel.png

               

              cheers

               

              Craig

              1 of 1 people found this helpful