Hi, please how to create a pivot table on looker
Solved! Go to 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.