How to make Report top 20 item sales

emre · May 10, 2016, 2:36am

fyi… While trying to implement a SQL solution I noticed I didn’t added {Start} {End} tags for date filtering at {REPORT SQL DETAILS}. That will work fine on next (.60) update.

[Top 5 Orders:1, 1]
>Item Name|Total
{REPORT SQL DETAILS:
   SELECT Top 5 MenuItemName,Sum(Price*Quantity) as Amount FROM ORDERS
   Where CreatedDateTime > '{Start}' and CreatedDateTime < '{End}'
   Group by MenuItemName
   Order by Amount desc:
F.MenuItemName,F.Amount}