Gauge dynamically displays value after filtering in another visualization

Hi everyone. I hope someone can help me.

I have a relatively complex query that I display as a table. The table is set up so that I can filter each row. Among other things, I have the quantity column.

Currently, I have this column displayed as the bottom column for a total quantity → which is filtered, of course.

However, I would like to display this number in a second visualization → e.g., a gauge.

In other words, when I filter something in the table, the gauge automatically adapts to the filtering of the table.

Wishful thinking → In the table settings, I can tell a column that it is now the variable $quantity.

I then display this variable in the gauge.

I hope you understand what I want.