Filter table box rows by range

[mokitsu61]

Hi

My question is about filtering rows of Tablebox.

Tablebox:

key | value

1 | A

2 | B

3 | C

4 | D

Listbox of "key":

1

2

3

4

When we select "3" of Listbox, Tablebox shows follow,

3 | C

* key = 3

But I want to make it as follow

3 | C

4 | D

* key >= 3

Does anyone know the way for it?

[sagar_puri]

Try This,

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value)

Regards,

[mokitsu61]

Thank you for your replying.

How specify the value of [Value] when [Value] are several items?

I'm really happy by your response and I want to realize your advice on my PC.

MY DATA (Over 1,000,000 rows) :

KEY| VALUE1 | VALUE2

01-Apr-2010 | A | a

01-Apr-2010 | B | b

02-Apr-2010 | C | c

03-Apr-2010 | D | d

...

31-Mar-2050 | ZZZZZ | zzzzz

Thank you.

[sagar_puri]

Hi,

I hope this is what you are asking, Keep the Dimension as Key and add 2 expressions here,

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value1),

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value2)

Regards,

[mokitsu61]

Thanks!