Have pivoted dimension under the measures so you can compare side-by-side

I have two items that I want to compare on a few different metrics. Unfortunately, the Table look seems to only allow the pivot dimension on top of the measures. While I understand how this limitation may seem logical, it makes it quite difficult to compare the pivoted columns, which somewhat defeats the purpose of pivoting in the table. 

This is my data table in BigQuery

DateItemMetric 1Metric 2Metric 3
JanuaryA933200
JanuaryB10066400
FebruaryA933200
FebruaryB10066400
MarchA933200
MarchB10066400

I can load this in Looker and easily pivot this to:

 A  B  
Date123123
February93320010066400
January93320010066400
March93320010066400

But what I really want to do is compare A and B, not 1 2 and 3 within A: 

 1 2 3 
DateABABAB
February91003366200400
January91003366200400
March91003366200400

However, this layout of the table seems impossible in Looker without completely restructuring the data into long/tidy format and then doing a complicated join. I know how to do this in Excel/Sheets and Tableau, so I am surprised it's so difficult in Looker.

Is there a way to show the third table from the first table? The second table is very user unfriendly for this use. I am using Looker Core.

0 6 177
6 REPLIES 6
Top Labels in this Space
Top Solution Authors