Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Pivot table

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have problems with pivot table, when I have 2 measures in table, for example minutes and dollars.
    Example
    Source table:
    Month; Region; minutes; USD;
    1; A; 50; 100;
    1; B; 10; 150;
    1; C; 20; 200;
    2; A; 30; 65;
    2; B; 40; 100;

    What I want as a result of pivot table is something like this
    Month SumOfMinutes SumOfUSD
    1; 80; 450;
    2; 70; 165;

    and NOT what I get
    Month
    1 SumOfMinutes 80
    SumOfUSD 450
    2 SumOfMinutes 70
    SumOfUSD 165

    Could someone help me?

    [ This Message was edited by: ales on 2002-04-24 00:27 ]

    [ This Message was edited by: ales on 2002-04-24 00:28 ]

    [ This Message was edited by: ales on 2002-04-24 00:28 ]

    [ This Message was edited by: ales on 2002-04-24 00:29 ]

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello ales,

    The solucion is quite simple, just drag the field "Data" on the right and you'll get the data in the position you need,

    regards,
    Francisco

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, Francisco
    I cant move data fields in such position, it always appears like
    SumOfMinutes
    SumOfUSD

    and not
    SumOfMinutes SumOfUSD

    I use Excel 2000, not XP.



  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, ales,

    Frajaro is correct in what he says.

    On your pivot table, (not in the "Layout" section of the Wizard, you will have 2 grey boxes, Month & Data. It is this "Data" box that you grab and slowly drag to the right of your pivot table. As you grab it you will see a white box with a blue strpe in it. As you drag it right, the blue strip will eventually move to a different position - at that point let go and, hey presto, the table layout will be exactly what you want.

    Nobby


  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks a lot both of you,
    I didn't know that I can't do that with the wizard. It works now, and you really help me a lot.

    Ales

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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