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