View Single Post
  #5   Report Post  
Barb R.
 
Posts: n/a
Default

I did everything up to the "Click and Hold" part before. That did the trick!
Thanks a bunch!

"Ron Coderre" wrote:

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