How to do trellis drilldown from the results ?

[georgear7]

I have below query which will get results from other panels and corresponding results will get stored here. I have used global variable to get the results from other panels.

| makeresults
| eval AUGCB="$AUGCB-PROD$", AUCFS="$AUCFS-PROD$", AUVMA="$AUVMA-PROD$"
| stats values(AUGCB) as AUGCB, values(AUCFS) as AUCFS, values(AUVMA) as AUVMA

Currently my output showing as below after applying trellis. But i couldn't able to do trellis drilldown as my query doesn't have any Split by field. So requirement is how to make Split by field in my query for trellis drilldown. I tried to use both $trellis.value$ and $trellis.name$, but no luck.

[georgear7 · Accepted solution]

I could able to achieve trellis drilldown by using below query.

| makeresults
| eval _raw="Market Result
AUGCB $AUGCB-PROD$
AUCFS $AUCFS-PROD$
AUVMA $AUVMA-PROD$"
| multikv forceheader=1
| stats values(Result) as Result by Market

[georgear7]

@rnowitzki need your help here.