Filter of entries in the table

[Anonymous]

Hello,

I would like to know your advice of solving my problem. I have a table which has a structure as showed below:

Header 1	Header 2	Header 3
MatchID	HomeTeamName	VisitorTeamName

And I have separate table which has all team names. So I need to filter my table by Team name which can be in the field HomeTeamName OR VisitorTeamName

Do you have any ideas how to solve it?

Thanks,

[jwjackso · Accepted solution]

Add a column =Count({<HomeTeamName=P(TeamName)>}HomeTeamName) + Count({<VisitorTeamName=P(TeamName)>}VisitorTeamName)

Suppress zeros on the column and you can hide the column.

[Anonymous]

if it just to show such matches in a chart table - can be achieved through expressions like below.

Dimension - MatchID

Expression1 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}HomeTeamName)

Expression2 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}VisitorTeamName)

[Anonymous]

Thank you, but my question was solved in a previous answer

[Anonymous]

Thank you. I don't understand how it works, but it works and I'll try to understand proposed solution later!