Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
customer | customer_type |
a | 11 |
b | 12 |
c | 13 |
d | |
e | aa |
f | bb |
g | cc |
h | 11 |
i | bb |
j | 13 |
k | aa |
Hi,
I need your help 🙂
I have a table like this example.
Customer d has no customer type (null)
I need a view or count without Customer type 11
=count({<[customer_type]-={'11'}>}[Customer]
I need a table only without 11 like
customer | customer type |
b | 12 |
c | 13 |
d | |
e | aa |
f | bb |
g | cc |
i | bb |
j | 13 |
k | aa |
When I have a diagramm the count for Customer must be 9 (including the customer with Null expression.
How can I do it?
Thanx
=count({<customer=E({<customer_type={'11'}>})>} customer)
Thanx