Hello Markus.

Thank you for reaching out to us.

Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.

Thank you for your understanding.

1. You can use placeholders for filtering the table directly. For example, if you add %VAR1% as a predefined filtering value for one column, you could change it through the shortcode, like [wpdatatable id=1 var1=Munich] and it will filter the column where you added %VAR1% as a predefined filtering value, and show the table containing only "Munich" in that column.

2. I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.

You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.