2 Replies Latest reply on Sep 29, 2012 11:27 PM by Philip George

    How to eliminate Null values

    Philip George

      Hi,

       

      I have data like this.

       

      NameJob
      RamEng
      ArunDoc
      Ajith
      Samarch
      TomEng

       

      If I create a chart using this there will be a separate 'Null' will appear for job.

      If I create a quick filter on job then also 'Null' will appear for one of the checkbox.

       

      How can I avoid these Null values?  I dont wat to show 'Null' in the check boxes in the filter.I just need only the options Eng,Doc,arch.

       

      Can anyone help m on this.

       

      Regards,

      Philip George