Can any one explain how to diaplay fileds in table bix using expression in straight table

[#1]

Hi

Can any one explain how to display fileds in table box using Expression in Straight table.

Ex: I have one straight table as below

Project      Total      Red Zone (Red Zone = count of the "Key" if field X = 'ZZ')

A               10               0

B               5                 3

C               6                 9

D               6                 0

E               2                 1

F               2                 0

If i slect 3 in "Red Zone", then i want see corresponding 3 values in Table box.