3 Replies Latest reply: Apr 17, 2013 1:58 AM by jagan mohan rao appala RSS

    Rename Null Value Using A Calculated Dimension

      In a straight table, how do I replace '-' for null value with the word 'Unlisted'?

       

      Example:

       

      Current output

       

      Dimension     Revenue

      John              $20

      Brian              $100

      Fred               $45

      -                     $5

       

       

      Proposed output

       

      Dimension     Revenue

      John               $20

      Brian               $100

      Fred               $45

      Unlisted          $5