Hello Everyone,
I have a crosstab query that totals the stock adjustments by manual log number and also gives me the average for those same records by month (in bold below). What I'd like to do instead, is receive an average of the monthly totals that have populated as the year progresses.

I've tried a few different expressions in the crosstab query, a few different expressions running this through a simple query, and also tried a separate calculated field in the report I want to run, all without success.


PARAMETERS [forms]![main menu]![fiscal year] Text ( 255 );
TRANSFORM Sum([Stock Adjustments].Cost) AS SumOfCost
SELECT [Stock Adjustments].[Manual Log], Sum([Stock Adjustments].Cost) AS [Total Of Cost], Avg([Stock Adjustments].Cost) AS [Avg Of Cost]
FROM [Stock Adjustments]
WHERE ((([Stock Adjustments].FY)=[forms]![main menu]![fiscal year]))
GROUP BY [Stock Adjustments].[Manual Log], [Stock Adjustments].FY
PIVOT [Stock Adjustments].FM In ("January","February","March","April","May","June" ,"July","August","September","October","November", "December");

Is there a way to calculate this information the way I need or am I missing something?
Thanks in advance for your help and suggestions, I appreciate it.