3 Replies Latest reply: Nov 5, 2012 9:28 AM by whiteline _ RSS

    Show results with zero (not null) in pivot table

      Hi! 

       

      I´m trying to display a pivot table that has a column "Quantity" with zero 0 in it.

      When displaying the data through a table box I can see all the rows including thoose that have a 0 in column "Quantity".

       

      But when diplaying the same in a pivot table all rows are shown except thoose that have 0 in column "Quantity"....

       

      Please help me to display all rows.

       

      Thanks in advance.