Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a report that displays the Top 10 largest contributors, now I want to give users the opinion to dynamically change the number of largest by inputting their own number.Can anyone please walk me through thanks.
Looks like you have used Rank Function as either calculated dimension or in set analysis...
You can create a variable
vTOP = 10
Now create an input box and keep vTOP in that.. Use can chagne any number replacing 10.
Now in Rank where you have used 10, use $(vTOP)
if you have used Dimension limit
Select Largest and use $(vTOP) instead of 10.
Looks like you have used Rank Function as either calculated dimension or in set analysis...
You can create a variable
vTOP = 10
Now create an input box and keep vTOP in that.. Use can chagne any number replacing 10.
Now in Rank where you have used 10, use $(vTOP)
if you have used Dimension limit
Select Largest and use $(vTOP) instead of 10.
You used Dimension limits?
Declare a Input Field in the script and then in deimension limits or in set function use the Input field.