Pivot Table

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
 
G

Guest

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 table wizards 2
Aging Report 4
date filter in a pivot table 1
convert date to text month 2
Changing Date for Pivot Table Result 2
MS Excel 2003 - pivot table 1

Top