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.
Solved! Go to Solution.
Create a VC in table 2 with an expression like..
COUNT(
FILTER(
"Table 1",
[Sales Rep ID] = [_THISROW].[Sales Rep ID]
)
)
Create a VC in table 2 with an expression like..
COUNT(
FILTER(
"Table 1",
[Sales Rep ID] = [_THISROW].[Sales Rep ID]
)
)
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |