1 Reply Latest reply: Jul 24, 2013 5:50 AM by Tresesco B RSS

    Hide missing values from Pivot Report

    vikas mahajan

      Dear all

       

      I have pivot report I want to hide all values having zero's or null or -  in  , I tick option supress when values is null 

      option but still I am not able to hide this values.

       

      please help me to achive the same .

       

      Thanks

       

      Vikas

        • Re: Hide missing values from Pivot Report
          Tresesco B

          This does not work because, if one of your fields has 0 or '-' or NULL the other field has value for that record. if you want to hide the row for a certain field's content (0 or null or '-') then you have to put a conditional expression(presentation tab) for all the columns with same expression.

           

          Hope this helps.