pivot table

[tatuspark]

Hi, please how to create a pivot table on looker

[Eric_Lyons]

Hi @tatuspark,

Do you mean pivot an explore or do you mean you want to completely pivot a sql table in Looker? If you want just to pivot and explore, you can hover over the dimension you would like to pivot by and click the pivot icon. In the new field picker it appears like two arrows that form a right angle. In the older versions of looker the icon says pivot. 

This video has some more details. 

Please let me know if that works!

Thanks,

Eric

[tatuspark]

Hi @tatuspark,

Do you mean pivot an explore or do you mean you want to completely pivot a sql table in Looker? If you want just to pivot and explore, you can hover over the dimension you would like to pivot by and click the pivot icon. In the new field picker it appears like two arrows that form a right angle. In the older versions of looker the icon says pivot. 

This video has some more details. 

Please let me know if that works!

Thanks,

Eric

@Eric_Lyons  

i want to do a pivot table like this on excel is this possible with looker

[3Easy · Accepted solution]

Yes, very possible. The modern Table visualisation in Looker (not the Table (Legacy) visualisation) will do this, when you check  Subtotals at the top of the Data table.

You would prepare your Data table with three dimensions (two dimensions you want for your rows, and a third dimension you want for your columns, which you’ll pivot on), and one measure (to fill in the table). The second dimension will get the subtotals.

This is covered in the documentation for Table Chart Options, specifically in the section for Data Bar Options and Subtotals. Hope this helps.