Remember Me?

#1
February 14th 06, 09:01 AM posted to microsoft.public.excel.misc
 MarkN Posts: n/a
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
February 14th 06, 01:35 PM posted to microsoft.public.excel.misc
 bob777 Posts: n/a
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

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

#3
February 16th 06, 12:39 AM posted to microsoft.public.excel.misc
 MarkN Posts: n/a
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

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post tysop Excel Worksheet Functions 1 January 24th 06 06:33 PM Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM Spencer Hutton Excel Worksheet Functions 1 March 7th 05 04:07 PM yllee70 Excel Worksheet Functions 1 February 21st 05 10:49 PM

All times are GMT +1. The time now is 05:25 AM.

The comments are property of their posters.

"It's about Microsoft Excel"