Top Ranking Customers and Request

[pauln]

Following from the post below it seems that it is not so easy for Top 5 Customers.

How to make Report top 20 item sales

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}

As Customer is ENTITY how is it attached to Sales? There Account Transactions, Account Values, and Accounts and so on.

REQUEST:
@emre would be a good feature to be able to supply a Max Results Parameter to all REPORT TAGS. Therefore I could use the standard {REPORT ORDER:x} Tag - using Sum and Desc key words PLUS maybe MAX keyword to return only 5 lines.

No need for SQL DETAILS just would return TOP n / BOTTOM n for any Report Tag!

[pauln]

Just to show that I am not completely lazy:

[Top 5 Customer:6, 2]
>Customer|Total
{CALL:Max.Lines("{REPORT ORDER DETAILS:EC.Customer.Full Name,O.ExactTotal.sum.desc:(ODI=True) && (TCET=Customers):{0}|${1}}", 5)}

Fed into a Script to only return 5 Lines

[Posflow]

Hi @pauln , would you mind mentioning what function you used? split()?