Adding the option to use variables in the rows and columns of dynatables

An additional information to what others wrote too: using only a variable would mean it shows only one element. In almost all cases a subset with a variable is needed. Find here different use cases:
1. Choosing a combobox element like a product category (the value e.g. "Bikes" is in the variable) and in the rows all products below are shown. This can be enabled using a subset with a hierarchy filter.
2. Another example is when choosing in a combobox the value "Year-to-Date", then the chosen months in the columns are showing YTD instead of only a month. E.g. 2026-03 shows only the month March, but "YTD" shows 2026-03_YTD, which is the sum of Jan, Feb and Mar. This would be achieved with a named range and a IF formula and in the subset a hierarchy filter.

Hi,

I would add to the case here, that a usage of the subset editor in general would be highly appreciated. As stated by the creator, it (most) often is not the case, that a fixed row or column selection is used. In a standard planning application it is common e.g. to list elements based on a selection (combobox) from the canvas. E.g. show all cost centers of a specific legal entity or all products of a specific customer.

Thank you. To give more context, in the majority of tables created a dynarange is used. It is quite rare to create a table with hardcoded elements in the rows or columns. The most common setup is the dynarange returns a subset based on a combo box selection (e.g. children of the product group which is selected in the combobox, or months of the year selected in the combobox).

Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.