12 month unit sales

We can write this report for you if you want.

use the detailed sales report with the crieteria of the 12 month time period, then group by store and department.

Another way we have done this, is to set up an ODBC connection to the HQ database, then use Excel to query the report with this external database query:

select t.storeid,departmentid,sum(e.quantity*e.cost) AS Total from [transaction] t join transactionentry e on t.storeid=e.storeid and t.transactionnumber=e.transactionnumber join item i on itemid=i.id where time>dateadd(m,-12,getdate()) group by t.storeid,departmentid order by t.storeid,departmentid

Then use the Excel Pivot Table feature to show a grid of store by department. (Store > I need a report that would show 12 month sales across the board, by stores