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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (