Can you show me how you are using that Transaction sheet in Glide (both in the data editor and in the app layout), and how you are applying filtering?
Are you just using the native filtering with an Inline List?
If you are, then it won’t be possible to have dynamic rollups. To get those, you need to implement custom filtering. Have a watch of the below video to get an idea how that can be done: