Filter rows of a table with Enable Conditional?

[#1]

Hi

I want to create two separate straight tables for the same content, but in one table I want to show all the records that have the status = closed, while in the other table, I want to show all records that have a status = open.

I thought I could use the Enable Conditional on that used dimension and type in: DocStatus = 'Open'

All it does, it hides that dimension (column) but it still shows all records. How can I simply hide these records?

Obviously I can't use a list box, otherwise it will not work with the second table where I want to show the other records.

Any help highly appreciated.

[#2]

I found the solution.

Instead of the Enable Conditional, I have to use a calculated dimension using a If(DocStatus='Closed',DocStatus) and then check the "Suppress When Value is Null"