Straight Table : Filter

[#1]

I loaded a table from the database.  I am displaying that table using straight table.  It has about 100 Rows.  However, I need to display only the row, for which one of the field matches a specific value.   I tried calculation condition CENTER='5A9000P'  but that does not work.  It still displays all records.  How can filter the row with CENTER='5A9000P' ?

[jvitantonio · Accepted solution]

If you want to do it automatically, you need to use a chart instead of a table and in the dimension put

"=If(Center = '5A9000P', Center)

If you want to do it witha button, create a button, go to Actions, -->Add -->Select in Field. Put the field name and the value.

[#3]

Thank you .. it worked.  I chose Cross Tab and put the formula you wrote.  Also chose the option to supress null values.