PivotTable:Suppress rows with only 0 values

[Donari]

Hoping someone can help me with this. I have a list of 160 addresses and
columns that represent occurance of issues at these addresses. I want to
create a pivot that only shows the sites if there the value is greater than 0.

An example of the data in my spreadsheet

Site Issue 1 Issue 2 Issue3
A 1 0 0
B 0 0 0
C 0 1 1

I only want sites A and C to appear in the pivot and then sum the number of
occurances by Issue.

 

[Pete_UK]

If you sum the number of occurences by Issue in a separate column, you
can then apply autofilter to that column - select Custom, then Not
Equal To | 0 (zero) to hide site B data.

Hope this helps.

Pete