Trouble with calculated dimension ignoring selections

[Anonymous]

Hi everybody:

I'm trying to make calculated dimension ignoring part of the restriction of current selections.

I have data about a test. There are three teams that have passed the test. I have the name of the team members, the score they got in the test and the team they belong to.

I want to compare myself with the rest, so when I select a team in the team selector I want to compare the members of the team with me.

I have tried to make a calculated dimension in this way:

=Aggr(only({<Team={"*"}>+1<Name={'Me'}>}Name), Name)

but it doesn't work.

Can anybody help me?

[sunny_talwar · Accepted solution]

See if this is what you are looking for.

Dimension: Name

Expression: =Only({$+1<Name={'Me'}>}Score)

[Anonymous]

It was exactly what I was looking for.

Thank you very much.

[sunny_talwar]

Awesome