How to limit the data in a table using variable input box

[abc_18]

Hi,

I have created a input box, as a slider and I am using it in front end dashboard.

variable name is vTop10

Now I have a staright table, having one dimesnsion as 'Sales manger name', and multiple expressions.

I have to restrict the data in table based on input box selection, how to acheive this?

Thanks

[Seyko]

Hello,

Which do you exactly want to restrict? The values of the dimension, the calculations on your measures or both?

cordially.

[Yoshidaqlik]

Hi

would it decrease the number of rows in the table?
in your dimension put

Top10:

AGGR(
	if(
		Rank(
			your_expression
		,4)<=$(vTop10),
		[Sales manger name]
	)
,[Sales manger name])

Down10:

AGGR(
	if(
		Rank(
			your_expression * -1
		,4)<=$(vTop10),
		[Sales manger name]
	)
,[Sales manger name])

Regards