Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

LINKTOFILTEREDVIEW action based on same user but in different columns

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 Solved
1 7 289
1 ACCEPTED SOLUTION

And that's why you need to write.. LINKTOFILTEREDVIEW("Events Global", IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4])))

View solution in original post

7 REPLIES 7
Top Labels in this Space