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

    Eliminate rows with Zero values in a column..

      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:

      I want to eliminate those rows with zero quantity. But I need the TOTALS to be unaffected by this.
      My desired report:

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