Using Inline table to make top N selection + all values

[Stanislav1]

Hello there!

I will try to explain this issue to the best of my abilities. I have an inline table, which is connected to a button list, from where  a user can pick a selection from 3,5,10 to show the top 10 values in a table.

Inline table

Front end table

How can I make a selection, where the user can see all of the values from the selected measure? Thank you in advance

[deepanshuSh]

You can put an if and else condition, such as below in the limitation section and restrict the value based on the value section. Or in a better way create an variable and use variable input box for the same. 

if(Value =3, 3,
if(Value=5, 5,
if(Value=10, 10)))

[vinieme12 · Accepted solution]

Add Another Selection Value

_TopN:

load * Inline [

_rank_ID,_rankValue

1,3

2,5

3,10

4,ALL

];

Then instead of using Field Limitations use a Measure as below

=if(_rank_ID=4,sum(somemeasure) , if(rank(sum(somemeasure),4,2)<= _rankValue ,  sum(somemeasure)))

[Stanislav1]

Thank you it worked for me.