How to write an expression to limit what I see in a List Box

[#1]

Good morning all,

I have created a listbox for a column that displays dollar values. How do i write an expression that will limit the records displayed to those that are greater than or equal to one million dollars?

Also, let me know if I need to adjust any other settings like the number settings to make this expression work.

Thanks in advance,

Steve

[m_woolf]

For your dimension:

if(Amt>=1000000,Field)

Or in the expression:

Sum(${<Amt={>=1000000}>}AMT)