Where Clause for a Table chart?

[sicdude]

Ok so I would like to create a straight table chart with, let's say, 10 fields.  but I only ever want to show the records where one of the fields has a specified value (ex: dob>1/1/2000).  I don't want to have a filter on that field, I only ever want that data shown in that specific table chart.  

I have done this with bar charts and the like, but the "where clause" is usually in the calculated measure.  There is no measure in the table chart, only dimensions. I've tried using a calculated dimension similarly, but it does not work.  

I also can't do this in the data load as it would exclude information that I would need for other charts. 

[jwjackso]

When you drop the table onto the sheet, you can add both dimensions and measures.

You could use an "If" statement in the column like,

If(dob > '1/1/2000',dob,Null())

and suppress nulls on that column.

[sicdude · Accepted solution]

So it's not exactly what I was trying to do, but I ended up using an "action" on the sheet to force the value of that field to filter down to what I wanted.  So any time the sheet is entered, the filter is forced on.  I then did the opposite on the other sheets to force that filter off when those sheets are entered.

bit of a work around I guess, but it did what I needed