Hi, I created a bar chart with the Others expression. On the dimension limit tab I chose to show only the largest 3 values.
When I click on the Others now, I get again the largest 3 values (2 plus Others) and again, again..
All I wanted to show was the top 3 values (which I got),but when I click on Others I want to show all left values and not again top 3 (from the left). Is it possible to make it?
it's not possbile, you can create two charts one with the top3 (uncomment show other) and the second with a function rank in the measure to show all without the top 3
Can you please recheck the properties and also if possible can you change the value of 'Others' to some other name and test it and then filter for only Top 3 and also make sure you disable 'Show Others' checkbox
Create inline table as like
load * inline [
Write a condition in the measure that
if(getfieldselection(Optionsfield)='Top 3',"sum(condtion where you can exclude others )",
if(getfieldselection(Optionsfield)='Others',"sum(condition where you can exclude top3 )"