How to calculate how many clients meet the goal (conditions=OK, SALE>= threshold). When I select several products, I want to see how many clients meet the condition simultaneously. For example: Product A is only met by one client CUST1, but when I look at Product A+Product B, it is only met by CUST2, because the condition for CUST1 in Product B is no longer fulfilled. I ask for help. This is my last hope :) I need the table below.
This is an example, I have hundreds of products.
4 respuestas
@Ewa Muszańska could you please populate more data in an excel with few rows and the logic for what conditions you are looking for with an expected output. This way will have a clear picture on what you are trying to see the final output.
