count records which has common id in both tables

[deeavhad]

Hi, I have 2 tables and both has 'Profile id' as common field , now In Table1  I need to do a vlookup with T2 to look for exactly  same 'profile id'  and need to take count of matching 'profile id' for specific month.

I need expression for above condition, please help

[rwunderlich]

Is this in the script or in a chart?

-Rob

[deeavhad]

I don't understand where to apply, I think 1st need to do something in script and then in chart

[rwunderlich]

In a chart, the two tables will be automatically linked ("associated") by the common field.  So you can just count any field in table two. eg

Count(somefield)

If you have further questions can you post a screenshot from the data model viewer or some sample data?

-Rob