indirect set analysis

[felcar2013]

hi

i Need to calculate something like this:

Count(distinct Customer) where field1_ID = field2_ID

Customer and field1_ID are in the same table

field2_ID is located in another table

both tables are indirectly associated (there are like 2-3 tables between both of them)

it should be somthing like

count({<field1_ID = p(field2_ID)>} customer)

but it is not working. Any other idea?

thanks

[felcar2013]

your proposal is correct, though the credit went to Henric,... i realized it late your answer came first

thanks!

felipe