4 Replies Latest reply: Oct 30, 2014 10:44 AM by Ivo Marques RSS

    Show hidden values in pivot table

    Ivo Marques

      Hello everyone,

       

      So I am having some trouble with null values in pivot and straight tables.

       

      On the table box that follows I show 3 time values, but I want to use pivot or straight tables because I have to color cell based on a result.

       

       

       

      My problem is that both the pivot table and the straight table join two time results and show a dash ( - ) or 'null' instead.

       

      How can I show all the values with the pivot or straight table?

       

      Straight table:

       

       

      Pivot table:

       

      Thanks in advance.

       

      Best regards,

       

      Ivo Marques