4 Replies Latest reply on Jun 24, 2013 9:23 AM by Siddharth Surana

    Split one column into two, based on dimensions from another column

    Siddharth Surana

      Hey Guys

       

      I have a column which has a bunch of numbers and I would want to split that column into 2 based on a dimension field.

       

      For eg. Amount - Dimension

                       1000 - SFDC

                       2000 - DD

                       3000 - SS

                       4000 - SFDC

       

      Dimension Field - SFDC, DD & SS

       

      Now I would want to split the amounts based on the dimension and create new measure fields

       

      Does anyone have any ideas to do this

       

      Thanks

       

      Regards

      Sid