Filter the table with a chart expression

[alenb]

I have a table in which I want to show the certain subset of the data.

Brands:
LOAD * Inline [
Team, Brand
Team1, a
Team1, b
Team2, b
Team2, c
];

Teams:
User, Team
FRED, Team1
FRED, Team2
WILMER, Team2

In the chart expression for a table I want FRED table to show Brands a, b, c, and WILMER table to show Brands b, c. It would be ideal if chart expression remains the same for both tables, I just change the User part.

This is my pseudo-code attempt I put in the Field for the dimension in the table. Of course it doesn't work, but it "means" show only the Brands for Teams where User='FRED'. 

=if({${User='FRED'} Team }, Brand)

[MayilVahanan · Accepted solution]

Hi @alenb 

Try like below

=if(User='FRED',  Brand)

[Ksrinivasan]

hi,

Brands:
LOAD * Inline [
Team, Brand
Team1, a
Team1, b
Team2, b
Team2, c
];

left Join

LOAD * Inline [
User, Team
FRED, Team1
FRED, Team2
WILMER, Team2];

result:

ksrinivasan

[alenb]

It actually works! So simple 🙂