8 Replies Latest reply on Dec 3, 2019 12:19 PM by Bryce Larsen

    Create a calculated field to get a list from dimensions

    Abby Nie

      The data has a dimension called Orig, and it consists of CBS TV, Warner Bros, NBC Universal.


      Now I want to create a calculated field, that the outcome is a list with these three companies names


      This is what I do:

      I created a calculated field called [Create the list]


      IF FIRST()= 0

      THEN MIN([Orig])

      ELSE PREVIOUS_VALUE("") + ", " + MIN(([Orig]))



      Then I created another calculated field called [Orig List Table]


      WINDOW_MAX([Create the list])



      However, it seems that the code does not work as it only shows the CBS TV, but not the other two.


      Can someone help me fix this please?