Listing data from multiple tables in the “enumlist” column is done?
for example
SELECT(Table 1[Name], [Location]=[_THISROW].[Location]) =>> result: (A, B, C)
SELECT(Table 2[Name], [Location]=[_THISROW].[Location]) =>> result: (X, Y, Z)
SELECT(Table 3[Name], [Location]=[_THISROW].[Location]) =>> result:(U, V, W)
Valid_if how should I use a formula, to get the following result?
Enumlist (A, B, C, X, Y, Z,U, V, W)
One way is if you write the formula like…
SELECT(Table 1[Name], [Location]=[_THISROW].[Location]) +
SELECT(Table 2[Name], [Location]=[_THISROW].[Location]) +
SELECT(Table 3[Name], [Location]=[_THISROW].[Location])
thanks @Aleksi, I will try and return.
You’re welcome
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |