Top 10 of most sold articles / products
I'm trying to make a top 10 list of our most sold articles or products. I've got this table 'invoice lines' which contains all invoiced lines with articles and the amount of sold items. To build a dashboard with some sales info, I would like to create a portal to show the most sold items, later on to be specified per day, week, month... etc.
So far a Summarize field with a Count of ArticleID's didn't get me anywhere (obviously).
Hope you can point me in the right direction to get this done?
Thanks in advance!