Beast mode to count a variable with an if that reference other variable
I am trying to create a trend line of the total number of customers we have that have reached an X revenue threshold by month. I wonder how to best do that whether from a beastmode or something else.
The tricky part is that the data we have in domo is all written by revenue center in that one customer can have multiple revenue centers. So if the sum of all the revenue centers for one customer reach an X threshold than we want to include that customer in the total number of customers. If below the threshold, then it is excluded.
Thank you in advance for your help.
The data structure have four colums like this:
Date Customer Name Rev Center Revenue $