How to compare 2 fields in different tables

[rahulkatte007]

How to write the expression in pivot table to count the  field ADDR_NUMBR  by comparing the ID field from table1 to table2? 

Note: ID column is dimension in Pivot table

Table1

ID	ADDR_NUMBR
1	345
2	654
3	674

Table2

ID	FISVAR
1	QTE
2	ERT
3	FRE

[dplr-rn]

Not clear on what you mean.
if it is 2 different tables; it should be automatically associated and count should work.

Please expand with more details e.g. sample data, data model screenshots etc.

[Brett_Bleess]

Did Dilip's post get you what you needed, or are you still working upon things?  If Dilip's post was what you needed, please be sure to come back and use the Accept as Solution button on his post to give him credit and let others know it worked.  If you are still working on things, leave an update, and if you did something else, considering sharing that solution and marking it, so others will know that worked.

Regards,
Brett