Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following dimensions in my data model:
| Customer | Customer type |
| Customer1 | A |
| Customer2 | B |
| Customer3 | A |
| Customer4 | C |
| Customer5 | B |
| Customer6 | A |
| Customer7 | A |
| Customer8 | C |
I want to create a table in my app including customers with customer type A only:
| Customer |
| Customer1 |
| Customer3 |
| Customer6 |
| Customer7 |
How can I create such a customer list including customer with type A only?
I do not want to show customer type in the table and also I do not want to create a bookmark with customer type filtering the entire sheet (because other customer types are shown in other charts/tables in the same sheet).
Thank you for your assistance!
aggr(Only({<CustomerType={'A'}>}Customer),Customer)
aggr(Only({<CustomerType={'A'}>}Customer),Customer)
I would create the dimension in Script.
IF([Customer Type] = 'A', Customer) AS [A Customers]