3 Replies Latest reply on Jun 19, 2017 3:01 PM by Christian Berg

    Presentation Variable in Column Formula

    user 1208988

      Hi All.

       

      I have this requirement to show multiple values of presentation variable in separate rows in a table or pivot.

       

      For example, if I select three department names from dashboard prompt, the table/pivot will populate three rows representing a department.

       

      The column I am trying to populate is not modeled, it's SELECT_PHYSICAL query (to create the prompt).

       

      And then presentation variable in column formula of analysis.

       

      Result at the moment looks like Dept1,Dept2,Dept3 all in one row.

       

      My need is to show

       

      Dept1

      Dept2

      Dept3

       

       

      Thanks