Set up the basic Pivot Table with:
Row: Project
Data: FY02,FY03,FY04,FY05
Change the formulas from count to Sum
Create the Pivot Table
THEN...Click and HOLD on the Data column heading and DRAG it over the Total
column heading. RELEASE
The fiscal years should now run across the top of the table and the projects
should be consolidated down the left.
Does that help?
Ron
|