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-...

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