Looker subtotals not working properly

[carlosavendano]

Hi everyone,

We are facing some issues with subtotals in Looker since it seems to not show the proper value:

-If we dont use subtotals, we can see that the proper value (242) is showed for the row “LINK FINANZAS”:

-But if we turn on subtotals, we see just nulls values for all the rows:

If we open a buttom, we would see the proper value below it:

But thats not the expected behaviour, right? We should see the sum of that level in the top level, and if we open the buttom we should see the combination of subtotals; but it seems that it only shows the values in the levels below it.

Is it a bug? How could we solve it?

Thanks in advance

[jredl]

Believe it or not, thats the default way the table visualization works it seems. You can try turning on the “collapse subtotals” functionality but at the same time that isn’t ideal. I asked a similar question last year on this same topic: https://www.googlecloudcommunity.com/gc/Exploring-Curating-Data/Looker-subtotals-on-the-same-row-as-the-subtotal-is-for/m-p/576188#M4030

We opted to using the report table visualization from the looker marketplace instead of the default table that looker provides for reports that require subtotals: https://github.com/looker-open-source/viz-report-table-marketplace-open-source

[Vitalii_Godlevskyi1]

Hi everyone!
I have the same issue – I need to implement a PnL table in Looker dashboards that should sort items by category and display a subtotal amount below each category.

I’ve run into serious problems with the implementation and made many attempts, but without success. I tried using dashboard properties like hide_totals: true and show_subtotals: false, but they didn’t help. I also tried using a derived table to construct the main table and calculate subtotals, but had major issues with filters and sorting. I even tried using the explore/ visualization approach but got result when subtotals works wor all columns, but I need only one.

Is it even possible in principle to implement my template in Looker?
I would be very grateful for your answer!
This is my template