Forum Discussion
competition sales data analysis
I got two tables A & B. Table A has competition companies A1,A2 & A3 sales quantity for 3 product categories. Table B (my comapny) has sales quantity of same 3 product categories. The sales quantitie...
you would need to either union your two data sets together in Power Query or create a product table then create a relationship between the new dimension and your facts. the facts "US" and "Them" woould then be sliceable by the shared dimension products.
Good luck