Hello rafaelrook

Unfortunately wpDataTables doesn't have this kind of logic included, and this would only be possible to achieve with an SQL Query based tables.

However, it wouldn't be dynamic, meaning you couldn't use filters on the second table, but instead you'd create a table with this query:

SELECT country, state
FROM mainTable
WHERE Country = 'USA'

Or something similar.