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.
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"
