Issue with an average based on a specific filter

Hi,   Below is a simple represantion of the structure I'm dealing with. I want to find out average order value for apple, pears, etc but make sure it include other products in the average.   O...