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