Do u want something like this..
Plz see attached application.
Check the Constraints Tab of listbox if ur requirement fulfills.
ConfidTest.qvw 788.2 K
Right click on sheet
go to new sheet object
select input box chart
make a title any like top n customer
add a variable (click on new variable)
give name as N
go to constraint
check Enable edit Expression
Value - give any 10 / 20 etc
Value list - predefined values in drop drown - predefined values will get enabled -
select range - you can select list values to make exact range-
make a chart - select dimension as customer- expression sum(sales) - go to presentation -
select max number(1-100)- put name in expression as your variable (N)
by this when ever u will make query, this variable will response. like u slect top variable 6
top 6 customer's records are fetched from this query