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 Antwort
  1. 24. Mai 2019, 05:50

    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