Skip to main content

I want to count the number of account between sales team.

The rule is simple. If there is an account that is sold by more than one sales team, I would consider it as common account.

However, the rule only applies if the sales is within the last 365 days from the measured date.

I use the followings to count the Common accounts

My problem is, I can only count this at a single point of time.

How do I count this over a period of time? The 365 days window will have to move.

1 answer