Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Assistance Needed | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot table subtotals help needed | Excel Discussion (Misc queries) | |||
Pivot table assistance | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |