7 Replies Latest reply: Jan 18, 2013 2:57 AM by Narsimha CH RSS

    Hiding rows in pivot if one value is zero

      Dear All,

       

      I have attached the excel raw data and qvw file.

       

      I have put a pivot table in QV, however i need to hide the complete row if one of the value in the pivot is 0.

       

      Is it possible using expression in pivot table.?

       

      The final result should look like th below. Here it is hiding 3 rows where some value are 0 and displaying only two rows.

       

      H2ABCDEGrand Total
      ABC-100-150-50-45-75-420
      CDE-300-55-30-55-400-840

       

       

       

      Regards

      Nassar