Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 14th 06, 09:01 AM posted to microsoft.public.excel.misc
MarkN
 
Posts: n/a
Default Pivot Table Date Groups

Hello,

I would like to be able to group dates in the row area of a pivot table so
that items are grouped into Australian financial years (1st July 2005 to 30th
June 2006 etc). Can this be done? Any help appreciated.
--
Thanks,
MarkN

  #2   Report Post  
Old February 14th 06, 01:35 PM posted to microsoft.public.excel.misc
bob777
 
Posts: n/a
Default Pivot Table Date Groups


Set up a lookup table on a spare sheet that assigns the correct
accounting period to each of the 365 dates in the year, and add an
extra column to your spreadsheet headed acc_per

In that column =vlookup(ord_date, lookuptablename,2)

Then use acc_per in your pivot table.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=512148

  #3   Report Post  
Old February 16th 06, 12:39 AM posted to microsoft.public.excel.misc
MarkN
 
Posts: n/a
Default Pivot Table Date Groups

Thanks very much, problem solved...
--
Thanks,
MarkN


"bob777" wrote:


Set up a lookup table on a spare sheet that assigns the correct
accounting period to each of the 365 dates in the year, and add an
extra column to your spreadsheet headed acc_per

In that column =vlookup(ord_date, lookuptablename,2)

Then use acc_per in your pivot table.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=512148




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table and groups tysop Excel Worksheet Functions 1 January 24th 06 06:33 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
pivot table date field Spencer Hutton Excel Worksheet Functions 1 March 7th 05 04:07 PM
pivot table yllee70 Excel Worksheet Functions 1 February 21st 05 10:49 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017