How to make that a cell in a new table only shows a filter result of another table?

I have an entire table with all the data that I need and it already has filters, a total row and a couple of slicers. What I want to do next is to make a summary of the data after I filter it, basically a new table but it only shows the total amount of data after applying filters. I already tried using the subtotal function in the new table while referencing the original table with filters on it and also the row function. Any idea of how to do this or if is actually possible to do it?

edit: i have microsoft 365 for business version 2602

https://preview.redd.it/xcikij4fo3ng1.png?width=1920&format=png&auto=webp&s=9108876c9dc93a937de15550a25ae1fe7d1e8573