This can be done by creating a calculated field similar to the following:
total(sum([Order Quantity]))/total(countd(month([Order Date])))
Hope this helps!
Thank you for your quick response. The computation does work in TDE and SQL Server but not in Excel as data source (though this is fine since we will be using a database) -- I think count distinct is not an available function when connecting to Excel.
On the display side, I may be missing something, is there a way to display the average in between March and Grand Total or after the Grand Total? Thanks again.