I am working on creating a query in SQL to use on a report. I'm having trouble summing some values, so here is my question:
I have a table that shows how many inventory items were sold by period, by warehouse site, and the for each fiscal year. I have 5 warehouse sites, so each inventory item will have 5 rows of data (one for each warehouse site), and 12 columns (for each period (month)). Then each inventory item may have been sold during a fiscal year, so some items may have 2, 3, 4, or more years of data.
What I'm trying to do is sum each of the inventory items by warehouse site by fiscal year. So instead of each inventory item having 5 rows for each year, there will be one summed row for each year.
I hope I have explained what I'm trying to do well enough. Please let me know if I can help explain what I'm trying to do any better.