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
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.
quot;sndquot; wrote:
gt; I would like to build a pivot table report that has a layout of
gt; one field in the row region
gt; multiple fields in the data region
gt; each data field, reported side by side with appropriate column titles
gt; .
gt; the resulting report would could then look like:-
gt; .
gt; ROWTITLE SUM(Values) Count(Values)
gt; A 100 3
gt; B 200 5
gt;
gt;
- Apr 21 Sat 2007 20:37
how do I format data into columns using a pivot table report?
close
全站熱搜
留言列表
發表留言