My customer is asking for a count of active ( those with sales >0 ) for each of 2017, 2018, 2019
Have you found an easy way to do this? This seems like it should be simple ( and maybe it is an I'm missing something ).
1. I create three variables ( 2017-sales, 2018-sales and 2019-sales)
2. I test for each customer whether the sales reported from customer sales history have FYE and if so I put the value into the formula. If not I set the value to zero
3. Then I group on customer and subtotal the three variables
4. This works fine for creating a nice three-year chart of sales by customer
Where I'm stuck is getting a count of the number of those summarized sales that are 0
Running totals hasn't worked and I'm not seeing any workaround despite Googling like crazy
Has anyone run into this and found a resolution?
------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------