close

I am using pivot report. I am having monthwise qty in pivot report. ex.

Month Qty.
Jan 10
Feb 15
Mar 18
Total 43

I want in following in same report
Month Qty. Commu. Qty.
Jan 10 10
Feb 15 25
Mar 18 43
Total 43

can anybody help me in this regard. mail me at

A pivot table can display a running total, as described he

www.contextures.com/xlPivot10.html#Running

You may need to rearrange the data fields so they appear horizontally:

www.contextures.com/xlPivot02.html

wrote:
gt; I am using pivot report. I am having monthwise qty in pivot report. ex.
gt;
gt; Month Qty.
gt; Jan 10
gt; Feb 15
gt; Mar 18
gt; Total 43
gt;
gt; I want in following in same report
gt; Month Qty. Commu. Qty.
gt; Jan 10 10
gt; Feb 15 25
gt; Mar 18 43
gt; Total 43
gt;
gt; can anybody help me in this regard. mail me at --
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html

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

    software

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