Filter data in a table

[#1]

Hi,

I have some problem regarding filter data in a table:

look at the Period Revenue column:

Publisher	Period Revenue
AppBank  (Rubicon Project)	$2,364
Ace Top Media  2	$1,668
TLV Media	$2,876
Boxore.com	$2,137
Adnetwork.net  Premium Ads	$2,006

Lets say i want to show in the table only when the sum is above 2300$. So i enter in a Input Box this amount and i expect to see in the table:

Publisher	Period Revenue $
AppBank  (Rubicon Project)	$2,364
TLV Media	$2,876

How can i accomplish that?

Thanks,

Guy

[deepakk · Accepted solution]

Hi

Try out the attached application.

Deepak

[#3]

Thanks a lot, it is working now. just to clear it up:

1. if there is more than 1 column in the table, you should enter the expression (see bellow) in each of them (so all the row would disapear in case the condition hasn't met)

2. i changed your condition in the expression to be:

     if(vtest< Sum(Amount), Sum(Amount))

Thanks agian!

Guy