Hello Nik

Thank you for your interest in our plugin.

You should be able to do this with MySQL Query-based tables.

If you're not that familiar with MySQL queries, we do have WordPress database and MySQL database query constructors that can assist you in constructing a query, but please note that neither of these constructors is an ultimate query generator, so they will construct a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.

Please be advised that preparing MySQL queries for you is not included in the plugin support.