Filter number of rows

[amiroh81]

Hi,

I have data from multiple sources (mainly SQL queries).

In my model I built a table with a customer name and number of instances per customer.

I would like to build a button that will filter for the user only the customers who have under-X shows.

Actually it Sounds very simple and somehow I could not actually do it.

Can anyone help?

Thanks in advance

[pradosh_thakur]

Hi Amir

As we have not seen your data you have to be a more specific. That will help us help you better. I couldn't understand "Under x " shows part. Can you please elaborate a sample data would be a plus.

cheers

[amiroh81]

Hi,

This is example for the data

i want the names of all costumers under 10 times 

John	1000
Dan	500
Alex	400
Emma	50
James	10
David	5
Jason	2
Chris	2
Walter	1
Tayler	1

[pradosh_thakur]

Why do you need a button then ? Or you want to restrict the app to customer with count less than10 when you click that button ?

in the list box use

if(cust_count<10,customer)

[avinashelite · Accepted solution]

Create a variable like vShow and set 1 add this condition

if(vShow=1,sum({<Count={">10"}>}count), sum(Count))