Pivot Zero not required

[mustu2]

Hi

Thanks for reading the post. I have two different pivot from the same data source.

Pivot with employee name in row, month in column, and hours in value field.
Pivot with employee name in row, month in column, and Expenses in value field.

Now the problem is in each pivot the row is also displaying if the value field is zero (hours and expense). This results in too many pages and the report is too lenghty with zero values also.
Is there any way i can filter the value field so that it does not gives me Zero's (Note the value column is month)

Thanks

 

[mole999]

if you click on the row filters, you should be able to deselect zero, and blanks etc

 

[mustu2]

Sorry how do i do that, coz
Row is name so even if i filter does not equal 0, no impact
Column is month, cant filter that also

i am lost

 

[mole999]

http://www.pivot-table.com/

the things I'm thinking of is those circled in blue on that web page

 

[mustu2]

Thanks anyway for the replies, i tried this, its not working.