1 Reply Latest reply on May 23, 2020 3:31 AM by Jim Dehner

    Customers receiving cash from more than 10 unique sources during a month

    Chulaxshan Gunasegaram

      Hi Experts,

       

      I need to filter cx receiving cash from more than 10 unique sources during a month. Below in image, I highlighted in red color below count 10 but it filtering here.

      I tried the below calculation :

      IF { FIXED [Recipient Alias],MONTH([Trx Date]):COUNT([Initiator Alias])>10} THEN 1 ELSE 0 END