
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 件の回答
Yeok:
This should work :
COUNTD(
IF { FIXED [Account Name] : COUNTD(if DATEDIFF('day',[Date],today())<365 then [Sales Rep Team] end)}>1 THEN [Account Name] END
)
Thanks,
AB