I need to create a variance for year over year figures. The issue is the year is in only one column. If I have 2,000 lines, 1,500 have Aug 2014 in the column and teh rest have August 2013. They are not in seperate columns.
|Sum of USD Amt||Column Labels|
|Americas||1,332,127 ||3,127,969 |
|APAC||395,338 ||1,177,325 |
|Europe||6,949,294 ||9,025,668 |
|US||4,657,023 ||4,215,319 |