How to get top 10 stats with pivot command without using sort?

[Simon]

Hi all,

How can I get a top 10 statistic with pivot? Currently I'm doing something like

| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort 10 - count 

I'd like to avoid the sort somehow.

Thanks,
Simon

[dfigurello]

Hi Simon,

Try this search:

| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10

tks!

[bhawkins1]

I downvoted this post because doesn't answer the question at all.

[Simon]

This is the same as my search does.
I asked if there's a way to get the top10 statistics directly with the pivot command.

[spammenot66]

@simon what in the world are you trying to get at? Both solution seems to work when handling pivot