Exclude zero values using average function in a pivot table

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

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