Counting data from another table

[tomarnishant]

I have 2 Tables, Table 1 has Sales leads assign to specific users, and table 2 has names of Users. I want to fetch and print Count of Leads assigned to them from Table 1 and print them to Table 2 in front of respective users.

like a Pivot table in Excel where we can count data from another table.

[TeeSee1 · Accepted solution]

Create a VC in table 2 with an expression like..

COUNT(
 FILTER(
  "Table 1",
  [Sales Rep ID] = [_THISROW].[Sales Rep ID]
 )
)