Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I format data into columns using a pivot table report?
Try creating the pivot table with the row, no columns and all the data fields
in the data area. Once you visualice it, with everything on the rows and a single column, drag and drop the data header (the gray field with the drop down) to the columns area, and the layout will be in the way you want it. "snd" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
need to clear data references in pivot table report | Charts and Charting in Excel |