Dynamic Summary Virtual Column

In Microsoft excel, you can create a table that has filters. At the bottom of that table, you can create summary row, using subtotal function, that will aggregate the table based on how the data filtered in real time. Is there a way to set up something similar in appsheet?

I have a table that I would like to filter, by one column, and have the aggregated column (virtual column) only show filtered summaries.

Looking for any help. Articles, documentation, videos, etc.