null value in table box

[#1]

Hi,

I have two tables.

Table1

ID	ColA
1	A1
2	A2

and Table 2

ID	ColB
1	B1

I now added a Table Box with the three Columns und get the following result:

ID	ColA	ColB
1	A1	B1
2	A2	-

I want, when I click on the cell - (row 2, column ColB), that the row with ID 1 disappears. How can I achieve that?

Thank you for your help in advance.

Cheers

Jack

[Anonymous]

Table box is just a flat display of the table data you select ...

With a pivot or a straight table (graph) there are posibilities to do some expressions by not displaying null values etc.