I have a bar chart with 2 dimensions (country, Category Name) and one expression (sales).
In Property->Presentation there are the following settings on Country dimension:
- Dimension Limitation, Max visible numeber = 3
- Show OTHER Label is checked
In this way I have exactly what I want: the top 3 countries and all other countries grouped together under OTHER label.
For each country showed, sales for all category products are shown.
Now I try to chenge this chart into Trellis representation.
I'm expecting 4 graphs: one graph for each country that covers the 3 top position and another graph for All Other countries grouped together, but the fourth graph is not showed.
Why trellis representation ignore to group under 'OTHER' label all countries that doesn't cover the top N positions?
The Show Others is a setting for the underlying chart type, not for the dimension, thus if you limit your second dimension it would give you others in each of the subcharts of the trellis, however not on the trellis level.