Hi

I need help with pivot tables, for example the dates in the column section
are all individual dates eg " 31/12/03", I would like to group the dates into
either months, quarters while within the pivot table.

Can anyone help me.

Many thanks
bac

Thanks Bob, much appreciated

"Bob Umlas, Excel MVP" wrote:

Once the pivot table is created, right-click on one of the dates, select
group and outline, then group. Months will be preselected, but you can
deselect it or leave it and click on quarters.

"bac" wrote:

Hi

I need help with pivot tables, for example the dates in the column section
are all individual dates eg " 31/12/03", I would like to group the dates into
either months, quarters while within the pivot table.

Can anyone help me.

Many thanks
bac