LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Assistance Needed Barb R. Excel Worksheet Functions 0 May 11th 05 02:51 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot table subtotals help needed anthony Excel Discussion (Misc queries) 2 April 26th 05 12:47 PM
Pivot table assistance Deb Excel Discussion (Misc queries) 3 April 22nd 05 07:40 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"