+ Reply to Thread
Results 1 to 2 of 2

pivot tables issue

  1. #1
    Registered User
    Join Date
    09-11-2010
    Location
    london,england
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy pivot tables issue

    Hello,

    I'm facing an issue using pivot table made from these datas :

    name;dialed_number;duration (sec)
    oliver;123-456-789;43
    oliver;123-456-789;185
    peter;766-545-432;12
    peter;123-456-789;78
    oliver;334-554-667;187
    peter;999-666-765;234

    I want to create a pivot table giving me the count of dialed_number per name as follow :

    oliver -> 2
    peter -> 3

    all I'm able to get is :
    oliver -> 3
    peter -> 3

    any idea ?

    Tanks in advance !

  2. #2
    Registered User
    Join Date
    09-11-2010
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007
    Posts
    4

    Lightbulb Re: pivot tables issue

    That is because you have the name Oliver listed 3 times. Excel is counting the name, not the number of times a mumber was dialed. Set up your pivot table differently. I set up an example in one of my spreadsheets and it looks like this:

    Row Labels Number Count of Name
    ------------------------------------------------------------------------------------------
    oliver
    123-456-789 2
    334-554-667 1
    ------------------------------------------------------------------------------------------
    peter 3
    ------------------------------------------------------------------------------------------
    Grand Total 6

    What you can't see is the expand/collabse button to the left of Oliver's name. If it is collasped it will show that Oliver has MADE 3 calls total. Once expanded (like I have shown) it will show the number of times he called each number. Probably more of what you were looking for. Hope this helps!

+ 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