1 Reply Latest reply on Dec 9, 2016 2:54 AM by SANDIP SHARMA

    Joint 2 dimensions' values

    CHIN CHUAN GOH

      Hi all,

       

      Would like to know is there a way to joint 2 dimensions' values together?

       

      Example, with the below data, how do I make a new dimension with the outcome value like "Apple - Green", "Apple - Red", "Apple - Blue", "Orange - Green"... so total will be 9 values.

       

      I guess this requires creating calculated field. If so, what's the formula?

       

      Data

      DimensionFruitColor

      Value

      AppleGreen
      ValueOrangeRed
      ValueKiwi

      Blue