Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two column in same table like,TEAM_A and TEAM_B.I have joined in these two columns into one column as TOTAL_TEAM and COUNTRIES.Now i want to remove the selected value of COUNTRIES in TOTAL_TEAM column.For Example if i click 'india' in COUNTRIES,it should be only show the five counties name from TOTAL_TEAM with out the value of 'india',because india played only 5 match,Based on the Match_ID.
i have used one straight table with one dimension and one expression,
Dimension =Aggr(If(GetSelectedCount(COUNTRIES) = 0, Only({1} TOTAL_TEAM), Only({1<TOTAL_TEAM = e(COUNTRIES)>} TOTAL_TEAM)), TOTAL_TEAM)
Expression=Match_ID
If i click the 'west indies' of Country field,it shown only 4 values.but 'west indies' played 6 match,the result is given below,