Pivot tables

[danielroberts560]

Hi

I have a pivot table with names as row labels and the dates as column labels. The dates range from Jan 2010 to April 2011. Naturally the pivot table arranges the dates in order ie Jan 2010, Feb 2010, March 2010 etc. Is there a way of getting the pivot table to put Jan 2010 and Jan 2011 next to eachother so that I can compare Jan 2010 to Jan 2011. Also I will need it to total 2010 and 2011 seperately rather than the two of them together? Will I have to alter my source data?

 

[RoryA]

If you right click one of the date headers and chose Group, you should be able to group by year and month. This will create separate field for you and you can then arrange and total them as you wish.