Product Ideas
Share your suggestions and ideas. Vote on ideas you find valuable.
Share your suggestions and ideas. Vote on ideas you find valuable.
Do you want to play a crucial role in shaping Jet Global products?
This idea has been merged into another idea. To comment or vote on this idea, please visit JETESS-I-11 make "sort by sums" easier.
I would be really nice to be able to the same as you do in SQL with the command Group by.
So if I for example need to find top 10 sales items for 1 customer. then i can't use the flow field sales on Item. In SQL code I would just select sales, item no, customer no. Group by Item No. Where Customer no = XX
a simular function in Jet would really be nice. i have had several customers ask for top 10, items sales, per customer, per item category, Per country etc. etc.
Mike Seisbye
I'm thinking this is similar to an existing idea of making 'sort by sums' easier, and will merge this idea with that one. Technically, you can do what you are wanting using the sort by sums technique, as in this article - https://support.jetglobal.com/hc/en-us/articles/115006132828-.
If I have misunderstood please provide more information.
It could be a "simple" add to the NL function, just like Limit= you would then choose Group by and choose the group by field. while the only option now is to take out alot of transactions and then calculate. where the group by could reduce the output tremendiously and then also speed of the report. And then you didn't need after calculations.