Is there a way to get the top 10 count for a number of groupings eg:
Col1 Col2 Count
G1 SG1 10
G1 SG2 8
G1 SG3 6
G2 SG4 21
G2 SG5 5
G2 SG6 1
So I have the top 10 for G1 then the top 10 for G2
Just do this:
... | sort 0 - Count
| dedup 10 Col1