calculate total column after using sliders

Hi there,

i am currently trying to find a way to properly calculate the total column after using some sliders. For example, as you can see in the following image i have filtered the data using two sliders (left hand side) which results in 4 records in the table. However, the total in the column "No. of records" should be 4 not 40.  The column "No. of records" was created as a calculated colum using a constant number, in this case 1.

I appreciate if anyone here can help me to sort this out. The idea is to create a formula that counts the number of rows or records when using sliders to filter data.

Thank you