How do I find the top 3 fields per dimension (for all dimensions) grouped by platform?

[ausche]

Let's say I have dimensions like country, content, subscriptionType, and I'd like to get the 3 most common fields grouped by platform say web, app, etc. How would I go about doing this?

An ideal output would be something like this

-----  |country   |content         |subscriptionType
web|us,uk,camusic,video,audio|seo-trial,sem-trial,perf-trial
app|us, ca, ch|music, video, audio|seo-trial,sem-trial,perf-trial

[HiroshiSatoh]

Using the TOP command is like this.

(your search)
|top 3 country,content,subscriptionType by platform

results:

platform,country,content,subscriptionType,count

app,us,music,seo-trial,100
app,ca,music,sem-trial,50
app,ch,music,perf-trial,10
web,us,music,seo-trial,150
web,uk,video,sem-trial,100
web,ca,audio,perf-trial,30

[ausche]

That would be the top of those dimensions together, but how do we achieve top of each dimension independently?

[HiroshiSatoh]

Is it like this?

(your search)|top 3 country by platform
| append [search (your search)|top 3 content by platform]
| append [search (your search)|top 3 subscriptionTypeby platform]
| fields - count percent
|stats list(*) as * by platform