Lookup and totals

I have a table (A) with a column that contain IDs. I have another table (B) with a list of IDs.
I'd like to filter table A, to include all the values that match those in table B.
I've made a derived table from table A, and then used match to try and filter by the ID column in table But I think I might be approaching this incorrectly, as when I use an aggregate function to get a sum, it seems to still be the same sum as the full dataset. Am I perhaps approaching this wrong?

Hello Cwokral, welcome in this community!

if I understand correctly, you have a table similar to the following one:

And you have another table that contains the IDs to keep:

In that case, use the Keep/remove matching action:

The result will be:

I hope that this could help you!

1 Like

Thank-you for your welcome, and help. This solves it.