Average Cost Calculation AX 2012

I would like to calculate average cost for a particular date range. How can I achieve this? Do i need to utlize inventtrans? Average cost on the on hand form seems to be a moving target. I would be able to go to the past month and see the avg cost of an item.