How to average numbers greater than zero in a pivot table
 

I have created a pivot table with many zero values. Is there a way in the
pivot table to average only the values above zero. When I use the standard
pivot table average function it counts all the numbers in column.

I know how to do this in a regular excel worksheet, but the pivot table has
me stumped.