Pivot table x-axis dates

[srose88]

Hi,
I currently have a pivot table with various conditions as rows, and revenue split out by weeks as the columns but I need to group the columns into months - is this possible? At the moment its just summing the weeks.....

Row Labels	Sum of 21/01/2013	Sum of 04/02/2013	Sum of 28/01/2013
Company A
Revenue Type X	0	45.16129032	19.08602151
Sale Description 2	0	45.16129032	19.08602151
Sale Description 1
0	0	45.16129032	19.08602151
Revenue Type Y	196.1890244	405.4878049	304.4461382
Sale Description 2	0	175	73.95833333
Sale Description 1
0	0	175	73.95833333
Sale Description 2	32.69817073	38.41463415	38.41463415
Sale Description 1

<tbody>
</tbody>

Many thanks!

 

[par60056]

Can you add a column to the data the pivot table is made from with the formula "=month(DateColCel)"? Then you can add that as a column group.