close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()