Hi,
Does anyone know if (and if I can, how) I can create a group of Data using Let statment?
The situation is as follows: We have a group of suppliers, what we buy to each supplier is sold in different products, I want to create a group named as the product we sold with the sum data of different suppliers.
Example:
When we buy the services from suppliers A, B, C & D we sell to our customer Porduct A. In our Data base we only have info from the supplier, I want to create a group which summarized the info for suppliers A, B, C & D named Product A. So when I select "Product A" I can sum the cost from all of them and visualize it as Product A costs.
I know that if I create a variable SET vProductA= 'SupplierA', 'SupplierB', 'SupplierC', 'SupplierD';
I can apply a set analysis on my expression sum({< supplier_name = vProductA>} cost_of_production)
and I will have (for instance) four lines: Cost supplier A, Cost supplier B, Cost supplier C & Cost supplier D.
Anyway, what I need is to have one line showing (something like): "Cost of product sold A"
Thanks!
