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)
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |