
Hi! I am trying to build a smartlist of quantity sold per year. I have added to my default smartlist the column "qty sold" but I cant find the column for date.
Thank you!
*This post is locked for comments
I have the same question (0)Hi Claudia,
No need to reinvent the wheel. Take a look at this view by Victoria Yudin.
https://victoriayudin.com/2011/08/11/sql-view-for-sales-by-item-by-year/
Regards,
Kirk