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

Anonymous

Not applicable

9 years ago

Hi v-jiascu-msft,

Accept my sincere greetings.

Further, if i choose to do a union on two tables than i have to make their structure i.e no. of columns identical which i don't want to do on first place. I liek your idea of making multiple table. I tried to do so but somehow i am unable to resolev the issue. I have made a dummy data for you which is very close to my original data accept the no. of columns. For sake of dummy data i kept the no. of columns same in two dummy tables. Table one has my co. brand as apple & along with other attribute on which i would like to slice the data. Table 2 also have the identical data but in brand column i have made changes. Now i want to create a visual where i want to make a brand wise sales comparision of 2 weeks i.e 22-2017 & 23-2017 across different sales office. I hope you got the idea.