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