SumOver in a month per user

[thecuon119]

Hi,
I’m finding a way to count distinct companies having app_gross_com from 1M-5M in that month. This is my data

I want it to look like this

Thanks a lot !

[ErikG]

Hi @thecuon119 ,
Did you checked out.

distinct_countIf - Amazon QuickSight

BR

[thecuon119]

I did it. Btw, Could you tell me the difference between

1. sumOver(app_gross_com,[company_name, truncDate(‘MM’, transactions_date)], PRE_AGG)
2. sumOver(app_gross_com,[company_name,truncDate(‘MM’, transactions_date)])
3. sum(app_gross_com, [company_name,truncDate(‘MM’, transactions_date)])
   for me ? I already read materials but i didn’t really get it. Thanks a lot !!