Question

Pivoted columns collapse/expand

  • 13 April 2022
  • 1 reply
  • 106 views

Is it possible to organize pivoted dimensions/column headers so that they can be expanded and collapsed similar to how multiple dimensions for row headers can be expanded/collapsed using the subtotals option?


1 reply

Hi there, new to Looker myself but I have found the ‘Report Table’ from the market place to be the closest to an Excel pivot table. The dimension hierarchy cannot be collapsed/expanded, and you can only have two levels of dimensions, but it’s better than nothign!

https://marketplace.looker.com/marketplace/detail/viz-report_table

Reply