+ Reply to Thread
Results 1 to 5 of 5

Pulling out Top 10 from a Pivot Table.

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Pulling out Top 10 from a Pivot Table.

    Hi,

    I have pivot table data (attached) and I would like to know, on Excel 2003, how to pull out in to other rows, two things:

    1. How the Sum of the TOP 5 companies in 2012 has evolved over the last few years. i.e. this will bring the sum of the top 5 companies in 2012, and then find the sums of the those same 5 companies for the previous years.


    2. How to find how the sum of the top 5 companies, in each year has evolved between 2007 and 2012. This will almost certainly refer to more than 5 companies in total, because the top 5 companies is likely to change yoy as they gain and lose market share.


    It would be nice to do this intelligently instead of having to go through and sort the data for each year.

    A tough one! Thanks so much!!!!!!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Pulling out Top 10 from a Pivot Table.

    I have an alternative.

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: Pulling out Top 10 from a Pivot Table.

    I made this in excel 2007.

    top 5 (based on the sum of 2007).

    Filter => Top 10 (and you can then change that in 5).

    I don't know if this also is available in excel 2003.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Pulling out Top 10 from a Pivot Table.

    If I follow your request correctly, the enclosed should do the trick.

    Seeing that your profile indicated Office 2010, I updated the file to the new format.

    Due to the error values in your data caused by the source data being absent, the values for the other years cannot be calculated the same way. The results on this workbook show only the companies that don't have errors in their values.
    Attached Files Attached Files
    Last edited by newdoverman; 08-23-2013 at 10:24 AM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Pulling out Top 10 from a Pivot Table.

    Thanks all

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help pulling data into pivot table
    By do00103 in forum Excel General
    Replies: 1
    Last Post: 05-08-2012, 11:42 PM
  2. Pulling data for a pivot table
    By burnsbe in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 10:58 AM
  3. Pivot Table pulling deleted data
    By jbeal in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 11:01 AM
  4. Help pulling data from pivot table for calculation
    By mike703 in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 05:35 PM
  5. Pivot table pulling wrong value
    By RestlessAde in forum Excel General
    Replies: 1
    Last Post: 11-25-2005, 02:35 PM

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