Combining Aggr with set analysis

[Inch13]

Hello,

I hope that you will be able to help me. 

I need the AmountTeam by distinct TeamID. This aggr works for me:

if(( Sum(aggr((AmountTeam), (TeamID))))>10, (count (distinct TeamID)), 'select more')

But now I need to add a selected year to it. The one below does ignore the date:

if(( Sum(aggr((AmountTeam), (TeamID), (year='2020')))))>10, (count (distinct TeamID)), 'select more')

How can I include another condition? And also, I need to combine the part:

if(( Sum(aggr((AmountTeam), (TeamID))))>10  with this:

sum ( {1<[year] = {'2020'}, [productive] = {'1'} ,[work] = {control},[controlTyp] -= {'P'} >}  Fees)  /

count ( {1<[year] = {'2020'}, [productive] = {'1'} ,[work] = {control},[controlTyp] -= {'P'} >}  distinct TeamID)

I have tried to find a solution but non of them works. Could you please help me with this? 

Thank you very much!
Regards,
Inch

[abhijitnalekar]

Hi @Inch13 ,

Can you please share the screenshot, where you want to use the required the expression?

And it will be great if you share the sample data.