Suppress records from table based on select fields

[#1]

I have a table box loaded with all records from database. What I want to do is use select fields to suppress records from the table that meet those criteria. So instead of isolating criteria that meets the selects, I want to suppress those records that meet the selects and just leave those that don't in the table.

As an example - I have a select field: Region. I want to be able to pick "Midwest" region from that select field and the result is all records associated with "Midwest" region are suppressed from the table. Leaving only those records associated with the unselected regions.

I'm sure someone has accomplished this, so if you could point me in the right direction to previous discussions on this or provide the solution you found, that would be great.

Thank you.

[krishna_2644]

You cannot add expressions or conditions in a table box.

if you want to filter out unwanted data then use St table or pivot table.

you can filter the data only at script level, if you want to use only a table box.

[#3]

Krishna,

Thank you for the reply. I've converted the table to a straight table. Now how could I go about using my select field to suppress records from the table?

For example, I have a select field titled "Region". I want to be able to select "Midwest" from the region select group and have all records associated with the "Midwest" region suppressed from the table.

Do you know how to accomplish this?

[krishna_2644]

Could you please give me some sample data?

[awhitfield]

Hi Steve,

See the simple attached qvw, this excludes sales for the selected region and shows everything else, using sum({1 - $} Sales) as the expression.

HTH Andy