I'm new to tableau. I want to achieve that always the Bottom 5 Countries are shown. It could be that due to the filtering there are only 2 red bar charts with negative values. In this case it should only show those 2 negative bar charts. In any other cases it should show bottom 5 countries. I´m aware that this is possible through a parameter and TOP-Function in filtering. But since i´m using a set of two levels (SSAS Cube) to show the countries I'm not able to use TOP-function.
Thank you in advance!