Dimension={$(=Only({1} Dimension2))} in a Set-analys don´t work?

[adam1988]

Hi,

I've got problem with set analysis in table of Bankers. They can have two kinds of relationship with client (Dealmaker, Administrator) and I need to calculate balance for both roles in one table. (I hope it's clear from attached file). I was trying to find solution and all I've learned led me to do it like this:

sum({$<Dealmaker={$(=Only({1} Banker))}>} Balance)

or

sum({$<Dealmaker={'$(=Only({1} Banker))'}>} Balance)

But it doesn't work. I belive it has to be easy to solve but I'm realy lost. Could you please help me?

Thx.

A.

[Anonymous · Accepted solution]

Adam, try these (I assume the only chart dimension is Banker):
sum(aggr(only(if(Banker=Administrator, Balance)), Deal_ID, Administrator, Banker))

sum(aggr(only(if(Banker=Dealmaker, Balance)), Deal_ID, Administrator, Banker))

[adam1988]

Awesome, works just fine!

Thx a lot! I need to check aggr function to fully understand what you did there...but thx again.

A.