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]