2 Replies Latest reply on Jul 15, 2016 12:48 AM by piotr.biaka

    How to show all values from Calculated Field (even those with no match from CASE)?

    piotr.biaka

      Hi Guys,

       

      Let's assume that i got a source which looks like this:

       

      ID
      NAME
      1Anna
      2John

       

      And Calculated field like this:

      CASE [Name]
          WHEN "Anna" THEN "Anna"
          WHEN "John" THEN "John"
          WHEN "Brian" THEN "Brian"
          ELSE "NA"
      END
      

       

      So I'm putting this Calculated Field on my Row shelf, and it only shows two values: Anna and John. I would like to display Brian as well, even though it has no reference to my Data Source. How can I do that? I'm already showing empty rows/columns from Analysis menu.

      Thanks.