Within our Thinkwise application, we are currently testing the Excel filtering functionality in the Universal GUI (version 2026.13.0).
We noticed a difference compared to the Windows GUI:
- In the Windows GUI, the Excel filter on a column with a domain (combo) only shows values that actually exist in the current dataset (distinct values).
- In the Universal GUI, all domain values are shown, regardless of whether they are present in the current selection.
In our specific case, we work with a category / subcategory structure:
- Both are based on a single domain
- The relationship between category and subcategory is stored in a separate table
- In practice, a category is always selected
As a result, the Excel filter on subcategory shows a long list of (for the user) irrelevant values, while we would expect only the valid/used subcategories to appear.
Our questions
- Is there a way to configure Excel filtering in the Universal GUI so that only values from the current dataset are shown (similar to the Windows GUI)?
- Are there best practices for modeling scenarios like this (dependent domain values such as category/subcategory) in the Universal GUI?
- Or is this a deliberate design choice, and should this be considered a feature request/idea?