Pivot table - average to exclude zeros

[Alphazulu]

I'm using a pivot table to calculate average by selecting "average" from the Value Field Settings.

The problem I am running into is the pivot table is calculating the average and including the rows of the pivot table where zero (0) is the returned value.

I would like the average to only be calculated on on the rows where a value greater than 1 is returned.

Is this something that can be accomplished through the pivottable tools, options, formulas?

Thanks

 

[Haldoug]

I don't have a solution, but do you want a value of 1 to be in the average calculation also, so you want an average on any number >=1?