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...
Hi v-jiascu-msft,
My apologies for the delay in response. Got stuck in a project. Further, I tried your last provided solution. everything seemed good but whenever i tried to choose a date from the slicer i loose the value of brand from my own table . Only competitors brands & quantities are visible. The moment i unceck the date filter visual gets my brand too in it.
I am working to find out a way to resolve this.
Regards,
Hemant
Hi Anonymous
The field of date slicer should be from table "Week-calendar year". And the same with other slicers. The three new tables bring all together.
Best Regards!
Dale