LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Make pivot table with multiple "data" fields in columns not rows?

I am trying to summarize several calculations using a pivot table. When I
dump the information I want to summarize in the "data" section of the pivot
table, I can't get it to line up in columns. I have only been successful in
getting it in rows. Is it possible to have multiple "data" items but
summarize it in columns and not rows?

Example
Column information Data information Data Information Data
information
Item A Sum of Inventory Sum of Goods Sold Sum of On
Order

Thanks!
 
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
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
Multiple Columns for Pivot Table Marilyn Excel Worksheet Functions 2 December 17th 06 09:30 PM
[pivottables] multiple table selection fields update in one click... [email protected] Excel Discussion (Misc queries) 1 September 22nd 06 02:42 AM
Derived Columns in Pivot Table sa02000 Excel Discussion (Misc queries) 1 February 8th 06 07:18 PM
pivot table error (25000 rows!!) Craig_Richards Excel Discussion (Misc queries) 1 November 13th 05 06:52 PM


All times are GMT +1. The time now is 08:13 PM.

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"