pivot table

Hi, please how to create a pivot table on looker

Solved Solved
0 3 9,350
1 ACCEPTED SOLUTION

3Easy
New Member

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.

6f30e039-79ec-4684-8d84-a088d4708c8c.png

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

View solution in original post

3 REPLIES 3
Top Labels in this Space