Average based on combined data

[lvh519]

I have a crosstab query that takes data from multiple customers and combines it based on product sold. I want an average of the product sales across the months provided. For example, if it is March I want an average of the sales of a given product thru March (so not divided by 12). I have it working as just =avg([Total]).

However, if I have a product total based on 2 customers, it divides by 24. If it is a based on 3 customers it divides by 36 and so on. How to do I restrict the number of occurances to just the months on the given query/report? I have seen the DAvg function, but I can't figure out how to write the equation for it.

 

[lvh519]

I am attaching a copy of my database (with reports deleted due to size) that will show my queries and tables. I need to be able to get the average of a product for the months on a given query. Do I need another table and if so how do I set it up and link it??

Thanks.