Straight Table Dimension problem

[adiarnon]

hi,

i have a straight table

my dimension is -resource name

my expresion -sum({<project name=>}effort_hours)

my problem - when im choosing in a list box a project name i want to see only the resource name that taking part of this project,

but i see all of my resources becouse of the expresion.

what should i do to see only the resources that taking part of the project?

adi

[#2]

Hi Adi,  Create one more field in Script that is alias of 'project name'   Then use alias field in expression.  'project name' in list box.