Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot Table
Resolved · Low Priority · Version 2007
Reply Thu 30 Apr 2009, 16:55Delegate Nestor said...
Nestor has attended:
Excel VBA Intro Intermediate course
Pivot Table
Ho do you group dates in a pivot table in Excel 2007
For upcoming training course dates see: Pricing & availability
RE: Pivot Table
Hi Nestor
When placing data in a pivot table if one of your fields contains dates and you place it in the row section (for example) then as a default the system will group it by days.
This shows the sales per day
To view the data as Sales per Month, Quarter, etc then you do the following:
1. Right click one of the dates in the range
2. On the menu click Group
3. The Grouping dialog box apprears showing:
- The Start and End dates (Which can be changed and deselected
- A list of group types which can be selected alone or in groups
eg Group by Months OR Group by Quarters and Months
4. Click OK
The table should group according to your selection
Regards
Carlos
Thu 7 May 2009: Automatically marked as resolved.
|