Pivot off a pivot table

[Attila Fust]

I have a pivot table that gets data from a database which
contains summary data (rows) by month-year (columns) and
could contain up to five years of data. Here is an
example:

Aug-99 Sep-99 Oct-99 ......May-04
Region A Sales 35k 45k 50k ...... 85k
Region B Sales 66k 64k 70k ...... 101k

I need to pivot from this data to get only the current
fiscal year (eg. Aug 1, 2003 - Jul 31, 2004) showing in
the same format as the first table.

Is this possible to do?

Thanks in advance.

Attila

 

[Ken Wright]

I'd just add another field to the source table that designated the Fiscal year,
and then use that in the Page Fields on the Pivot Table, eg assuming your dates
are in Col A on your source table, in a helper column use the following formula
and copy down:-

=IF(A1<=DATE(YEAR(A1),7,31),(YEAR(A1)-1)&"/"&YEAR(A1),YEAR(A1)&"/"&(YEAR(A1)+1))

This will give you a list of 2002/2003s or 2003/2004s etc.