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!
Bookmarks