Dynamic Total / Subtotal for Datatable

Dash Python
1

Hello there!

I understand this question has been asked before, but just wanted to know whether anyone has found a workaround?

My question is version similar to the following:

Data table How to get sum of column (s)

Dash Table Total

# Built-in Summary Row that Responds to Filtering, Sorting, and Editing #433

I would like for it to show a total for selected rows only.

In my case, I would like to filter it by Day of the week (Mon - Sun), with multi select, so for example in google sheets it would be something as follows:

image

And if I filter it by Saturday and Sunday, the subtotal will change accordingly.
The subtotal’s formula is this : =SUBTOTAL(109,E5:E20)

image

At the moment I am using google sheets and it’s veryyyy slow because it’s a lot of data and calculations in Python are SOOO much faster. I thought about using pandas to just add an extra row at the bottom but as I would like for it to react to the filter’s in dash, it might not be the most efficient way… (not 100% sure it’s possible either)

This is a really important part of the report I am creating, so I haven’t starting writing any code. If this can’t be done then I’ll have to find something else.

If anyone has any advice that would be great!

2

Hi renee,

Here you have examples of how to make a graph with data filtered in a data table:

If you can get the data then you can manage it using Pandas to create a new table as you want.
I do not know if exist any other easyest solution.

3

Hi @renee,

Could you find the solution to create the subtotal based on the filtered data?

Facing same issue as yours.

Appreciate if you can share your solution. Thanks.