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?
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