Exclude zero values using average function in a pivot table

[abs]

I am trying to sum up the average value in a pivot table, but the result are
including the blank cells give me an incorrect average value

 

[scubadiver]

=sum(XX:XX)/countif(XX:XX, ">0")