Table Boxes - hide certain values?

[#1]

Hi all -

Suppose I have a table box displaying a number of values across a number of fields.

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
Rocks	UNKNOWN	Dirt	Cement	John	1000	ADK	Accounting
Stick	11223	Dirt	Sand	Dave	1245	ADK	Expenses
Sticks	UNKNOWN	Water	Sand	Randy	882	KFL	Expenses
Soil	12522	Dirt	Cement	Sue	9912	PLK	Accounting
Masonry	18297	Water	Gravel	Larry	9901	KPA	Management
Masonry	UNKNOWN	Water	Gravel	Larry	9901	KPA	Management

If I just put in the fields (Column 1-8), the table would display exactly as above.  What if, however, I want to display the same fields but hide all lines where the value is UNKNOWN for Column 2?  Thanks!

[its_anandrjs]

Try with expression

If( [Column 2] = 'UNKNOWN' , ' ', [Column 2] )

[#3]

As the calculation condition?

[maxgro]

is it an option to add a listbox?

=if([Column 2]='UNKNOWN', 'UNKNOWN', 'OTHER')

[#5]

No - the object must display as a table so that it can be exported as such to Excel.

[Anonymous]

Hi

You  can create a  calculated dimension

if( [Column 2] <> 'UNKNOWN' ,[Column 2] )

[#7]

Would this be done in the Load Script, or elsewhere?  There's no option for a calculated dimension in a Table Box.

[Anonymous]

right clik on your table properties in the dimensions tab , there is a button called add dimension calculated

[#9]

No, there's no Dimension selection in a table box. Build a new Chart Box with Dimensions selected as the same columns in your table and add a single expression to count the lines (you can hide the expression). Now you can add a new calculated Dimension as above.