Quick Pivot Table formula question
 

How can i create a field in a pivot table that takes an average of
non-blank only data in a certain column ? I tried to create a formula
but it does SUM of the non-blank averages and doesnt offer the ability
to average it.