Is it possible to Transpose multiple dimensions in a table view?

Looker Q&A Looker
, ,
1

Hi Lookers,

I am working on a requirement to create a transaction search report.

The report will need to use a drill to functionality; where the user can search for a particular transaction and be able to view the receipt details upon clicking/selecting a particular ‘Receipt No’(dimension)

The data source is a single table created using BigQuery.

Report 1: Click the receipt No and be able to view Report 2( Receipt Details)

Report 2:

However, the requirement is to have a transposed view of the receipt details(report 2 above)

Example from Tableau:

Report 1:

Report 2:

I am looking to replicate similar layout and UI in Looker and seeking advice.

I am trying to create a ‘drill to’ using custom html. But, need help to transpose the layout.

Thanks in advance.

2 Likes