+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Pivot Table Dilemma

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Pivot Table Dilemma

    Hi everyone,
    I am brand new to this site, so if a similar problem has already been discussed I apologize.

    Anyways, for my new job at an orthopedic company I have been asked to create a list of Top 100 Independent Hospital Networks (IHNs) based on their total revenues (these are basically organizations that buy my company's products). Under each hospital network there is a long list of individual hospitals, so obviously the best way to summarize the data is through a pivot table. However, some listed IHNs are divisions of others. For example, one is simply called "HCA" with its own list of hospitals while others are "HCA-Central Atlantic Division," or "HCA-Virginia Richmond Division" with their own lists of hospitals.

    So. My excel skills are decent, but I am clueless when it comes to pivot tables. When I create a simple pivot table, it adds all of the revenues for the individuals hospitals under each IHN name, which is great; however, I would like to put the ones with different divisions under one main name (i.e. all HCA divisions, and their hospitals, under HCA). Is there anyway I can do this? Not all of the IHNs have seperate divisions, so would I have to create a macro that could let me do it to a select few?

    Any help on this issue would be greatly appreciated.

    PS) I apologize, but I cannot attach the file due to company policy, so if there needs to be more clarification, just let me know.

    Thanks!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Pivot Table Dilemma

    Hi,

    After getting two new knees last year, I'm here to help. See the attached to see if it does what you need.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Pivot Table Dilemma

    Wow thanks alot. I think I can definitely incorporate that format.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Pivot Table Dilemma

    Hi,

    You can also collapse the North, South, East, West groups by clicking on the minus sign just to the left of them. This will allow you to see a shorter list if you desire.

+ 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