LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
snd
 
Posts: n/a
Default how do I format data into columns using a pivot table report?

I would like to build a pivot table report that has a layout of
one field in the row region
multiple fields in the data region
each data field, reported side by side with appropriate column titles
..
the resulting report would could then look like:-
..
ROWTITLE SUM(Values) Count(Values)
A 100 3
B 200 5


 
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 from 3 columns of raw data with headers William Elerding Excel Discussion (Misc queries) 2 April 3rd 06 01:15 PM
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
How do I get more columns in a pivot table? bpeltzer Excel Discussion (Misc queries) 0 February 4th 06 07:10 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
need to clear data references in pivot table report Mikeeusa Charts and Charting in Excel 3 April 28th 05 08:57 PM


All times are GMT +1. The time now is 01:28 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"