+ Reply to Thread
Results 1 to 2 of 2

Need help pulling data into pivot table

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need help pulling data into pivot table

    Hello all

    Let me explain what exactly it is that I am trying to do.

    I have an excel sheet. In this excel sheet there are stores categorized by which regional office they belong to. So for example, ATL001, MIA002, BIR001, and CHAR001 might belong to the Knoxville, TN Southeast regional office. Likewise, PHX001, LV002, OAK001, and SF002 might belong to the Los Angeles, CA regional office. There are many stores belonging to a regional office and they are quite a few regional offices. I also have a pivot table that I have created to better organize and analyze the metrics of each store. This is where my problem comes in. Because the stores are organized by regional office, I would think that I'd be able to add the regional office and display the metrics FOR EACH store under that particular regional office, but I haven't been able to thus far. Instead, I have to add each individual store under the regional office, which is a tedious and mundane process. I am hoping someone knows of a better way to do this.

    Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: Need help pulling data into pivot table

    any chance of a sample file of your data (dummy data is its sensitive) so that we can see the layout of what you have?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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