Average calculation with "Zero" valued months

[JulesVerne]

Dear Friends,

I have a table about product sales. (StockCode, SalesDate, SalesAmount)

Sales

And I want to get this table :

Average Chart

Average-1 : Divided By Count(MonthName)

Average-2 : Divided By Count(Has Value MonthName)

Could you help me please..

Regards

[edwin]

the answer will depend on more detail that you can give.  assumptions can be made, since you wanted the average with 0 sales - this means there has to be a row for the month where sales=0.  

if you specify an expression avg(x), 0 values will be included automatically - Average 1; if you dont want the 0 values included add set analysis to exclude them avg({<x={"<>0"}>}x) here is a sample: