How to create a table visualization with sub totals including table calculations

[Rene_van_der_Vo]

Hi there, im new to looker but im trying to create a table in a dashboard where the user can easily fold and unfold the subtotals.

So far the standard subtotal function in looker gives a weird kind of miscalculation on the subtotals and each first row on a set has no data.

We also tried a custom visual however this doesn't work with table calculations. Ideally we would also like to sort on a measure instead on the dimension alphabetically.

The animation on the custom visual shows what we want to achieve but without the short commings as mentioned above.

https://looker.com/platform/blocks/viz/table-with-subtotals

Any advice how to make this?

[Dawid]

Did you install this custom visualisation? What does your code look like? What is the expected result?

[Rene_van_der_Vo]

Hi Dawid we installed the custom visual however our table calculations in the table are not visible in this custom visual anymore.

Expected result is a foldable table with working table calculations (Year over Year difference through an pivot) and ability to sort on a measure.  

The custom visual is a .js file we added.

https://looker-custom-viz-a.lookercdn.com/master/subtotal.js