Hi everyone,
I’m trying to build a P&L table in Looker dashboards with the following requirements:
-
Items should be sorted by category
-
A subtotal row should appear below each category
I’ve run into several issues and so far haven’t found a working solution:
-
Tried using dashboard properties like
show_subtotals: false, but they didn’t help -
Tried creating a derived table to calculate subtotals, but ran into major problems with filters and sorting
-
Tried the Explore/Visualization approach, which does generate subtotals, but it applies them to all columns and groupings, whereas I only need them for a single column
Question: Is it even possible to implement this kind of subtotal layout in Looker? Or is there a workaround/best practice for this use case?
Any advice would be greatly appreciated!
Here’s the template I’m working with:
