Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous

 

Could you please mark the proper post as answer if it worked? More about this topic, please feel free to post here.

Best Regards!
Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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