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?



        • 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.


            Real EstateReal Estate
            Real EstateOther
            RenewalsReal Estate


            and this is what you need


            Real Estate
            Real Estate Renewals
            Consumer Renewals
            Other Renewals


            Use the below.


            Create calculated field



            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"





            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?







              1 of 1 people found this helpful