How to only filter the subtotal amount of my transactions without removing the totla price?

Thank you all for your support so far. I'm almost done with everything thanks to ebveryones help. There is just one small step that I need help with and it's the one as follows: Look at this data.

Data / Doc / Serial No. / Value /

AAA / 999 / 123456 / $50.00 /

AAA / 998 / 123456 / $10.00 /

AAA / 997 / 123456 / $15.00 /

Total 123456 Value / $75.00 /

Data / Doc / Serial No. / Value /

AAB / 999 / 123456 / $50.00 /

AAB / 998 / 123456 / $10.00 /

AAB / 997 / 123456 / $50.00 /

Total 123456 Value / $110.00 /

And so forth... The thing is that my total value $100.00 is the total amount of the transactions I'm working with. I need to figure out a way to filter ONLY the total values. For instance, I want every transaction that has a total value of $100.00 or more to show up. So I don't want to see anything related to all AAA, but I DO want to see every transaction related to AAB since when they add up the go above $100.00. I tried using regular filtering option and it filters out all under $100.00 values, without taking in consideration if added up they go above $100.00 or not. All my transactions are already separated by serial numbers with subtotals on them. All I need is a way to get all those above $100.00 transactions in one sheet to clasify them properly & them place them back with the rest.

Thank you everyone for all your help so far!