How to let Pivot Table ignore ZEROs from the data while calculating Average and Average of Average?

Hello,   Thank you for your time to review my post.   I have a huge database being supported by pivot tables and pivot charts. The field value used is Average. I am trying to find a way that pivo...