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
|