Counting data from another table

AppSheet AppSheet Q&A
1

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.

tomarnishant_0-1671182255977.png
tomarnishant_0-1671182255977.png1529×560 53.9 KB

2

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

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