Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Field Grouping
|
|
|
Bookmark this page|
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 Field Grouping
Resolved · Low Priority · Version 2003
Reply
Pivot Table Field Grouping
Where I have used the field DATE as the field to group, I have selected DAYS, MONTHS and YEARS from the list in the Grouping box. This works very well, except for the result in the DAY column which lists each day in the format 21.Jul for example.It would be more useful if the name of the day (e.g. MON) was displayed instead as this would then allow a user to analyse trends based on years, months or days of the week. Do you know of a way to overcome this problem?
Regards,
Graham
For upcoming training course dates see: Pricing & availability
RE: Pivot Table Field Grouping
Hi GrahamThanks for your question
To group in the way you are requesting, you would need to group on "weekday", which is unfortunately not available in pivot tables.
One solution would be to insert a column into your data, and insert the weekday function. This function converts a date into a number that represents the day of the week on which it falls. You can then use this field in your pivot table as a row or column field, and the data will then be grouped as you require.
Regards
Stephen
Wed 10 Mar 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Database |
What is the purpose of database
