SumOver in a month per user

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 !

Hi @thecuon119 ,
Did you checked out.

BR

2 Likes

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 !!