comparison chart using powerpivot with same set of two period data

[pkseenu]

Hi,

I have two tables in excel for Q1 and Q2 with same column headings Region, Product name, version details, OS type, Total count. Data contains dubplicate values (i.e. in region field same region name will appear more times same for other columns). I want to compare these two table data and create a comparison chart for each product....

Thanks in Advance!!

 

[Carlos77]

Okay so I think for item level lookup and comparison powerpivot is not that effective when I will have to do the manual work on the tables. Although its relatively easier/faster and less prone to errors as compared to vlookup in excel.

I will try and share the model later today to get better advice.