I constructed a pivot table to consolodate and show sales by date. The data has the detailed date, ex. 15/01/11. In the pivot table I just want the month and year to show, so Jan 11. Is there a way to adjust the pivot for this?

Thanks for any help in advance!