Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table data 2
Change quarters in Pivot table when grouping 1
Pivot Tables and Fiscal Year 2
Rank in Pivot Table 3
Pivot ungrouping on refresh? 3
First Pivot Table 4
Pivot table setup 2
Pivot table 1

Back
Top