Hello
I have a SPtable containing
Idnr , Region , City , Village , Team
I have 5 Regions with max 10 Citys , max 15 Villages and tehy can have max 5 Teams
I want to set a filter in the gallery so it shows
Regions with the Citys and Villages without duplicates
I have been trying with GroupBY and Filter , i can only see one column
GroupBy(Filter(tbl_teams;region=ddregion.SelectedText.Value);"City";"region")
Any idea how to think here
Solved! Go to Solution.
Try:
Try:
Distinct(tbl_teams,Village )
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Nice workaround , but the names of the teams can be the same
Show a sample of your table and if you can explain further
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Here is the table
id region city village team
1 | W | Avesta | Fors | 8 - 10 |
2 | W | Avesta | Fors | 11-13 |
3 | W | Avesta | Avesta | 14-15 |
4 | W | Avesta | Avesta | 8 - 10 |
5 | W | Falun | Bojsenburg | 11-13 |
6 | W | Falun | Bojsenburg | 14-15 |
7 | V | Västerås | Bäckby | 8 - 10 |
8 | V | Västerås | Eriksberg | 11-13 |
9 | V | Västerås | Eriksberg | 14-15 |
10 | X | Gävle | Hille | 8 - 10 |
11 | X | Gävle | Hille | 11-13 |
12 | X | Gävle | Bomhus | 14-15 |
Try:
User | Count |
---|---|
252 | |
106 | |
88 | |
51 | |
44 |