Hello,
I am trying to figure out how to make a query that will have total sales (by quantity) of every product by year?
Table SalesProduct has SaleID, itemID, Quantity fields (and a few others not relevant right now).
Table Sales has SaleDate, SaleID (and a few others not relevant right now).
Is there any way to provide that information in a single query? I know how to extract for each year (separate query per year), but maybe there is an easier option?
Idea is to have years in rows, ItemIDs in columns.
Thanks.
I am trying to figure out how to make a query that will have total sales (by quantity) of every product by year?
Table SalesProduct has SaleID, itemID, Quantity fields (and a few others not relevant right now).
Table Sales has SaleDate, SaleID (and a few others not relevant right now).
Is there any way to provide that information in a single query? I know how to extract for each year (separate query per year), but maybe there is an easier option?
Idea is to have years in rows, ItemIDs in columns.
Thanks.