Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Date Grouping

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Table Date Grouping

Resolved · Medium Priority · Version 2003

Reply Wed 18 Mar 2009, 15:29Delegate Linda said...

Linda has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pivot Table Date Grouping

Can the Pivot table group by function (eg for dates) have customised ranges (eg, by a business financial month as oppose to a calendar month)?

Any help appreciated

For upcoming training course dates see: Pricing & availability

Reply Fri 27 Mar 2009, 17:43Trainer Amanda said...

RE: Pivot Table Date Grouping

Hello Linda

Thank you for your question and welcome to the forum.

Would it work if you chose to group by a number of days rather than by months?

This way you can specify a start date and enter the number of days from the start date that are included in the financial month.

You might only be able to see one financial month at a time, but at least this would give you a different grouping than a calendar month.

Kind regards
Amanda

Fri 3 Apr 2009: Automatically marked as resolved.

Excel articles

· Excel: From The Basic To The Advanced
· Replacing Cell Formats In An Entire Excel Workbook
· How To Use The Research Functionality In Excel 2010
· Training Budgets In A Bad Economy
· How To Pick The Best Chart Type In Excel

Please browse our web site to find out more about
excel+training+best and other Microsoft training courses.

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips