Suppress value in Pivot table

[#1]

Hello,

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.

Thanks,

Ralph

[SunilChauhan]

presentation supress zero value

and in dimension supress null value

hope this helps

[#3]

Hello Sunil Chauhan,

I tried both but it didn't work.

Thanks voor the responds.

Greetz,

Ralph