2 Replies Latest reply: Apr 18, 2012 6:32 AM by ralph snijckers RSS

    Suppress value in Pivot table



      In the attached QLV datafile I want to suppress all the "0" (null) or ( -) value's in the "PIVOT" table.

      I only want to see the rows where a score is filled in (last colomn "Rapportcijfer")

      See attach Word "example Report".


      Question 2:

      How can I connect the average of the "rapportcijfers" in the Pivot table with the Gauge chart.