![]() This can be anywhere from 4 to 10+ tools just to rank. field A 'desc', field B 'asc', field C 'desc'). and becomes even more long-winded when you want to sort on multiple levels (e.g. This is a lot of steps for something so simple.Īlso, if you want to analyse (just say) the top 100 you need to use a few tools just to sort and create a ranking and then filter. ![]() Or you could create a field with 1, sort by customer and then sold in descending and do a running total (grouped by customer) then filter to only keep where this running total = 1 (ie. Just to get the records with a top value you would have to use summarize tool and group by customer and get max sold in and then join back to the original on max sold in = sold in and customer = customer. I think there are many use cases but as a couple of examples:
0 Comments
Leave a Reply. |