Ignore dimension using set analysis

[#1]

I had posted a similar question few days back.... got a partial solution... thanks to John Witherspoon! I am trying to figure out how to ignore the dimension of the chart in 2nd column... tried different options found on this forum but so far couldnt get it working..

My straight table has one dimension as - TIER and 3 expressions as below -

=sum({$<TEAM_LEVEL_1_ID={1183693,1666316}>}AM_NET_CVA_ASGN_DELTA*YTDFlag) //hidden

=sum({<TEAM_LEVEL_1_ID={1456936,1456946,1496168,1633418,1732884,1045468,1413639,
1456935,1204825,1456297,1633417,1717014},YTDFlag={1}>}if(TIER=TEAM_LEVEL_1_NM, AM_NET_CVA_ASGN_DELTA)) //hidden

= Column(1) + Column(2)

What I want to do is - for each row (TIER), get the CV amount from 2 teams - 1183693,1666316. This is first column, gives correct result.

Now I also want to get the CV amount from the team where team name matches with the tier name. This is the 2nd column. But now the problem is amount calculated is crosssection between the TEAM_LEVEL_1_NM and TIER. Rather I want to ignore the TIER completely in this calculation and just want to get the sum of CV for the corresponding TEAM_LEVEL_1_NM

Appreciate any help... Thanks!

[#2]

Take a look about AGGR function.....

i´m not sure about your doubt.....but i think that function can help you!!!