currently I build a skill tracker to keep an overview, who learned what in my team.
The core table looks like this:
I use some extra tables for reporting. One of them looks like this:
In the 2nd table I would like calculate the “agents trained” column. Here I would summarize, how many agents have been listed for each topics (so unique name counts).
- Logistics: 6 people
- Security: 3 people
Every agents has several skills to be trained on and has several rows within a topic with his name listed in the core table.
I tried this formula:
[Complete Data Base].Filter([Complete Data Base].Topic= thisRow.Topic).Countunique([Complete Data Base].Name)
But it only shows all unique agents in every row… The Topic filter does not impact the result here.
Any idea on how to solve this problem?