View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default 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