Hi,
I don't know if someone has faced a similar challenge before. In case of that I would appreciate if you could link me to another thread that could be helpful.
However, the problem is the following:
Description of the data:
- Annual sales data by customer and product.
- The fact table has three columns: Customer_ID, Product_ID, and Sales_amount.
- There are Dimension tables for Customers and Products. There are hundreds of thousands customers and tens of products/services.
One customer may have bought only one product or all the products, or everything in between.
Challenge:
Now I would need to build a slicer based on Products that actually filters customers (and not products). The target outcome would be that by selecting a Product (or multiple products) the slicer would filter only those customers that have bought the selected products (sales amount greater than 0 in each selected product). This would enable a user to analyse what other products the customers that are buying a Product A, are buying. E.g., enabling her to analyse cross-sales potential etc.
I guess this would require some calculated fields and/or columns to find a solution for this. The ideal solution would not mind what or how many products there are otherwise the solution would not be as robust.
I am very grateful if someone could point me towards the right direction with my problem
Joona
I don't know if someone has faced a similar challenge before. In case of that I would appreciate if you could link me to another thread that could be helpful.
However, the problem is the following:
Description of the data:
- Annual sales data by customer and product.
- The fact table has three columns: Customer_ID, Product_ID, and Sales_amount.
- There are Dimension tables for Customers and Products. There are hundreds of thousands customers and tens of products/services.
One customer may have bought only one product or all the products, or everything in between.
Challenge:
Now I would need to build a slicer based on Products that actually filters customers (and not products). The target outcome would be that by selecting a Product (or multiple products) the slicer would filter only those customers that have bought the selected products (sales amount greater than 0 in each selected product). This would enable a user to analyse what other products the customers that are buying a Product A, are buying. E.g., enabling her to analyse cross-sales potential etc.
I guess this would require some calculated fields and/or columns to find a solution for this. The ideal solution would not mind what or how many products there are otherwise the solution would not be as robust.
I am very grateful if someone could point me towards the right direction with my problem
Joona
