+ Reply to Thread
Results 1 to 3 of 3

Problem with pivot table

  1. #1
    85225
    Guest

    Problem with pivot table

    I am trying to create a pivot table. I have the following fields: cust#,
    item#, and quantities for different months.

    I want the pivot table to look like this:

    data
    cust item jan feb march
    123 1 1 2 3
    123 2 4 5 6
    124 1 1 1 1


    etc


    But I am getting

    cust item Data
    123 1 sum of January 1
    sum of February 2
    sum of March 3
    123 2 sum of Jan etc


    How do I do this?

    Thanks!

  2. #2
    Debra Dalgleish
    Guest

    Re: Problem with pivot table

    In the Pivot table, drag the Data field button onto the cell that
    contains the word Total. There's a picture here:

    http://www.contextures.com/xlPivot02.html


    85225 wrote:
    > I am trying to create a pivot table. I have the following fields: cust#,
    > item#, and quantities for different months.
    >
    > I want the pivot table to look like this:
    >
    > data
    > cust item jan feb march
    > 123 1 1 2 3
    > 123 2 4 5 6
    > 124 1 1 1 1
    >
    >
    > etc
    >
    >
    > But I am getting
    >
    > cust item Data
    > 123 1 sum of January 1
    > sum of February 2
    > sum of March 3
    > 123 2 sum of Jan etc
    >
    >
    > How do I do this?
    >
    > Thanks!



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  3. #3
    85225
    Guest

    Re: Problem with pivot table

    Thank you,

    It worked.

    "Debra Dalgleish" wrote:

    > In the Pivot table, drag the Data field button onto the cell that
    > contains the word Total. There's a picture here:
    >
    > http://www.contextures.com/xlPivot02.html
    >
    >
    > 85225 wrote:
    > > I am trying to create a pivot table. I have the following fields: cust#,
    > > item#, and quantities for different months.
    > >
    > > I want the pivot table to look like this:
    > >
    > > data
    > > cust item jan feb march
    > > 123 1 1 2 3
    > > 123 2 4 5 6
    > > 124 1 1 1 1
    > >
    > >
    > > etc
    > >
    > >
    > > But I am getting
    > >
    > > cust item Data
    > > 123 1 sum of January 1
    > > sum of February 2
    > > sum of March 3
    > > 123 2 sum of Jan etc
    > >
    > >
    > > How do I do this?
    > >
    > > Thanks!

    >
    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1