Thread: Pivot Table
View Single Post
  #1   Report Post  
Bob Umlas, Excel MVP
 
Posts: n/a
Default Pivot Table

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