Pivot Tables and Dates

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jonsamson@xxxxxxxxxxxxxxxx
Date: Fri, 28 Mar 2008 10:08:09 -0800

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

In my Windows version of Excel, when using Pivot Tables, I could take a range of dates (i.e. transactions) and GROUP them in the Pivot Table (right click on the field) so I could get them by year or month instead of individual dates. I have a range of transactions, and my pivot table has a row of Dates and the amounts in the data field. I get a list of all my transactions by actual date. I'd like to show the amounts by year. Help.

Thanks
.

Follow-Ups:
- Re: Pivot Tables and Dates
  - From: JE McGimpsey

Prev by Date: Re: How To Edit Pie Chart Legend Labels?
Next by Date: Re: Excel causes system freeze
Previous by thread: Re: How To Edit Pie Chart Legend Labels?
Next by thread: Re: Pivot Tables and Dates
Index(es):
- Date
- Thread