Help needed with Aggr() function

[#1]

Hi

I have the following data:

And my problem is the following:

As you can see I have a client ID with two closed dates. The issue is that I need to count only the "Promoter" category for August, but the count is giving me the total of 5, instead of 2... how can I fix this?

As you can see in the second chart I have a column that uses Aggr() to get the max closed date, but I don't know to make the column "count" to count only those and ignore the data from January.

Thanks a lot for your help on the same.

Regards,

[#2]

Hi, whenever I have this issue, I just use a simple "Sum(if", e.g.

Sum(if(NPS_Category='Promoter',1,0) and it worked fine for me:

[#3]

Thanks a lot sunindia‌.... it seems to be working and giving me the number I need. Thanks for you help, now I will try to apply the same logic to fullfil the need we have.

Really appreciate it!!