I would like to know if there is an option on dimension limits which enables the restriction across 2nd, 3rd expressions based on a variable unlike restricting only on the first expression.
For Eg , if I have 5 expressions and I set a variable which states which expression needs to be used as criteria for restriction like i may want to see top 10 sales or budget or whatever depending on the user selection.
The alternative I have used to get this is by using using aggr and rank function but as its not performance is not good i am trying to use dimension limits.
Maybe use a hidden first expression (hide in presentation tab) and an expression that just expands to a reference to one of your main expressions using Column() depending on the user's selection of sort column.
Thanks Stefan, that works but I have query here suppose I am showcasing top 10 values and 2 rows are at the 10 th position so will both the rows appear on the chart showing 11 rows or will it randomly pick one of the two rows and show only 10 rows in the chart
Dimension Limits should always display the no more than the specified number of rows. If there is a tie for last place, it will pick one (or some) of these rows, up to the required number. I'm not sure if there's any particular logic to which of the rows it will select - it seems arbitrary to me but there's probably some underlying logic.
