May be remove the Pick(match()) around.. I meant like this
if(Aggr(Count(DISTINCT Product_Tower),Product_Tower)>0,
if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap and WildMatch(LABEL,'*NoMode*')>0,JIRA_KEY_ID)),[Sub-Capabilites])>0,'R',
if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap ,JIRA_KEY_ID)),[Sub-Capabilites])>0,'G',
if(aggr(count(Distinct if(WildMatch(LABEL,'*NoMode*')>0,JIRA_KEY_ID)),Capabilites)>0,'R',
if(aggr(count(Distinct JIRA_KEY_ID),Capabilites)>0,'G','B')))))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
