Hi Fadi,
The easiest way to deal with the scenario you are facing is actually to copy all of your 2013 data into your 2012 table, refresh the model, and drag the Year onto the columns. That should sort it.
In the grander scheme though, the challenge you are having is that your data sources need to be taken back into a normalized form. To make PowerPivot truly sing, you need to have a table that includes your columns A:M, as well as a Calendar table. You'd link both the calendar and the first table to your individual year's data and you should be able to report on what you need. As your data is currently set up though, it's going to cause you grief, I'm afraid.
Bookmarks