Pivot on Merge query

abhineet1
Participant I

How to apply pivot in merge query dimensions

0 1 397
1 REPLY 1

Ryan_PS
Participant III

I don’t think pivots work in merge queries. When I first tried, Looker said that the pivoted query must not be the primary query in the merge. But even when I made the pivoted query the 2nd query, the measure that’s supposed to be pivoted ends up showing up as a single column with null values.

Top Labels in this Space
Top Solution Authors