Good afternoon,
I would like help with a specific issue. I searched the topics but couldn’t find it.
I need to create a table chart with 3 dimensions, 3 pivoted dimensions, and 3 measures.
I would appreciate assistance with this construction. I tried using the native table view in Looker, but it only allows one pivot. I tested the table view (report), but it no longer allows two pivots.
How could I create this type of dynamic table?
Hey,
Hope you’re keeping well.
Looker’s native table visualization only supports a single pivot dimension in Explore, so building a table with multiple pivoted dimensions directly in the UI isn’t possible. To achieve a multi‑pivot layout, you’ll need to restructure the query in LookML by creating a derived table or using a SQL Runner query that pre‑pivots the data in SQL, then expose that as an Explore. Another option is to pull the data into Looker Studio or BigQuery, handle the multi‑pivot transformation there, and then visualize it with a custom table chart. This approach gives you full control over the pivoting logic before rendering the table.
Thanks and regards,
Taz
