Variance in a pivot table

[bronxram]

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
Row Labels	813	814
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
Grand Total	13,333,782	17,546,281

<TBODY>
</TBODY>

 

[Oeldere]

The issue is you have one column with august 2013 and august 2014 also in the same column?

You want to extract the year (or month) in a seperated column.

In that case you could use =month(a2) for the month and =year(a2) for the year.

After that you are able to select those criteria in your pivot table.