5 Replies Latest reply: Dec 22, 2015 11:08 AM by Sunny Talwar RSS

    How to create a second column from a dimension value.

    Betul Korkmaz


      Hi, I was hoping someone here would be able to help me.


      I have the below data and would like the dimension data as value in one column (as the results pic), instead of 3 records.

       

      So the first Channel in 'Channel 1', the second Channel in 'Channel 2' - this is in order by 'TV_Date'

       

      I managed to display the first value by the below code, but need help on the following columns...

       

      =FirstSortedValue({<TV_Date={'=aggr(min(TV_Date), FTVID)'}>}Sender, TV_Date)

       

      Any help appreciated!

       

      Best,

       

      Betul

       

      Data

      data.JPG

      Results

      results.JPG