2 Replies Latest reply: Dec 2, 2012 7:38 AM by 913864 RSS

    Eliminate rows with Zero values in a column..

    user8840662
      Hi all,
      I have a requirement, where in I have a pivot tabl.
      I need to check a column, if that column has a Zero, I need to get rid of those rows in the report. BUT, I need to have the TOTALS unaffected because of this.

      I tried filter on column in the report like this: COLUMN A IS NOT EQUALTO 0. I see the those rows are not shown in the report, But I see there is a change in TOTAL line.

      I have a small example in the images.

      This is my current report:
      http://i.imgur.com/mvxSD.jpg

      I want to eliminate those rows with zero quantity. But I need the TOTALS to be unaffected by this.
      My desired report:
      http://i.imgur.com/ob5fo.jpg



      Unable to figure out how to implement this. Any ideas?