I am having trouble to create a formula to calculate something on selective items in a dimension. Simplified example is as follow.
1. Products A, B, C and D defined in a list
2. Clients 1, 2, 3 and 4 in another list
3. Production costs calculated at the client level based on the products (any and all) they have
Now I need to sum the by-client production costs for products A and B only and make it as Z. How to create a formula to achieve that? I tried to use the SELECT function [Select: Products.A, Select: Products.B] and it did not work.
I am new to Anaplan so any advice in detail is appreciated.