I have two tables:
1. Users (the KEY COLUMN is "CODICE FISCALE")
2. Events (the Associated columns are: "User1" "User2" "User3" "User4" )
I am creating a view based on table "Users" with a LINKTOFILTEREDVIEW action button,
and when I click this button I would find the Users if it is present in one of "User1" "User2" "User3" "User4" columns.
If I try with
LINKTOFILTEREDVIEW("Events Global", [User1] = [_THISROW].[CODICE FISCALE])
it works, but I would include all the other 3 situation.
And so also "User2" "User3" "User4"
Basically I would like to find the Users in the entire "Events Global" view, regardless if it is present in the columns "User1" "User2" "User3" "User4".
How could I proceed?
Solved! Go to Solution.
And that's why you need to write.. LINKTOFILTEREDVIEW("Events Global", IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4])))
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |