Hi Simon,
Try this search:
| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10
tks!
I downvoted this post because doesn't answer the question at all.
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.
@simon what in the world are you trying to get at? Both solution seems to work when handling pivot