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]))

      END

       

      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?

       

      Thanks