Calculated Values on a Filtered Table

Hello everyone,

I have a data collection file with some calculation created. I would like to get my calculations (Column O) to work when I filter the table. How can I get the calculations to work when I filter the table?

Attached here is the file for your references. Appreciate the help and support from you guys here! Thank you so much!

Hi there,

Thanks! The subtotal function works!