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 quantities are collected weekly i.e once in one week. I need to analyse 8 weeks of data wherein i need to prepare a dashboard in which i need to show my company data along with other company's data. Moreover, need to show how much we sold a certain product & how much is sold by competition for some chosen week.

I am able to create dashboard on each table independently. Somehow i am not able to create a dashboard wherin i can show mine & competition companies sales data together.

Any guesses how to start it??

Regards,

Hemant