Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
|
|
|
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 Tables
Resolved · Low Priority · Version 2010
Reply Fri 16 Dec 2011, 16:58Delegate Hatice said...
Hatice has attended:
Excel Advanced course
Excel Intermediate course
Pivot Tables
Hi,
How do we group data on pivot tables? For example; I have 12 months, 10 stores and sales value and I would like to group sales per 10 stores and under 4 quarters rather than seeing 12 indivisual lines for months. I hope my question is clear.
Thank you
Hatice
For upcoming training course dates see: Pricing & availability
RE: Pivot Tables
Hi Hatice,
Thank you for your question and welcome to the forum.
If you right click over a cell in your Pivot Table with a date in it and Choose Group. A dialogue box should appear giving you a list of different time formats. Unselect the formats you don't want and then just select(in your case Qtrs).
I hope this answers your question.
Regards
Simon
Wed 28 Dec 2011: Automatically marked as resolved.
|