This content has been marked as final. Show 2 replies
I'd like to filter the clients based on the following conditions
The client has 3+ distinct ERC# within the last 12 months or 6+ distinct ERC# since 1/1/2014.
To break it down, there're multiple calculations that need to be included in the filter
1. How to count distinct ERC# within a date range
2. How to combine the two conditions together
3. How to put them into a filter
Sample data attached, please help!