Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a number of Customers where the orders are at a specific phase, see below example, I only want to count those customer where all orders are at phase 11, Customer A has some but not all, Customer C is the only Customer where all orders are at phase 11.
I want to display the result in a Text Object
Customer | Order ID | Phase |
A | 1 | 10 |
A | 2 | 11 |
A | 3 | 11 |
A | 4 | 12 |
B | 5 | 2 |
B | 6 | 1 |
B | 7 | 1 |
B | 8 | 1 |
C | 9 | 11 |
C | 10 | 11 |
C | 11 | 11 |
C | 12 | 11 |
=Count({<Customer=E({<Phase-={'11'}>}Customer)>}Distinct Customer)
That did return the correct result, can anyone else help?