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?
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 )"