PivotTable:Suppress rows with only 0 values
 

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.

PivotTable:Suppress rows with only 0 values
 

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

On Aug 12, 11:48*pm, Donari wrote:
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.