Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Which do you exactly want to restrict? The values of the dimension, the calculations on your measures or both?
cordially.
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