5 Replies Latest reply: Nov 21, 2012 5:49 AM by Thomas Jensen RSS

    Display name by using key

      I want to display a name by a ID, so i can identify if have 2 same names but with 2 different keys (ID)

       

      I got this expression

       

      =if(DWID_Medarbejder <> 1888, DWID_Medarbejder)

       

      This shows all my workers ID except 1888. How can i comebine a name on this?

       

      So i would get for an example

      "Thomas Jensen 454"

      "Michael Hansen 455"

      "Thomas Jensen 456"

      "Peter Pedersen 457"

      and so on

       

      And how do i do it in a bar chart? Is that just a calculated dimension?