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
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
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.
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks