+ Reply to Thread
Results 1 to 4 of 4

Pulling Data from a Pivot Table

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    23

    Pulling Data from a Pivot Table

    I am attempting to automatically pull data from a pivot table. The numbers I am trying to extract are sums which correlate to an account number, but in addition to the account numbers (which repeat) they are also broken down by 2 more layers of sorting that also need to be extracted. Ultimately, I am trying to build a table that sorts the data by these three ID numbers. I tried using GETPIVOTDATA but was unsuccessful. Does anyone have any suggestions? Thank you in advance for any help.

    Unit Invoice Number Invoice Date Account Number Description AMOUNT
    RALBR-310 3154192364 72400 $107.38
    RALBR-310 3154192365 $39.15
    RCLIF-310 3154192366 $84.48
    RCLIF-310 3154192367 $107.95
    Attached Files Attached Files

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

    Re: Pulling Data from a Pivot Table

    Maybe you can add the desiered result in your file (for better understanding).
    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.

  3. #3
    Registered User
    Join Date
    04-22-2014
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Pulling Data from a Pivot Table

    I am attempting to automatically pull data from a pivot table. The numbers I am trying to extract are sums which correlate to an account number, but in addition to the account numbers (which repeat) they are also broken down by 2 more layers of sorting that also need to be extracted. Ultimately, I am trying to build a table that sorts the data by these three ID numbers. I tried using GETPIVOTDATA but was unsuccessful. Does anyone have any suggestions? Thank you in advance for any help.excel forum.xlsx

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

    Re: Pulling Data from a Pivot Table

    Maybe a pivot table like this.

    See the attached file.

+ 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. Pivot table not pulling my NA values from data sheet
    By amberm0720 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2013, 08:17 PM
  2. Need help pulling data into pivot table
    By do00103 in forum Excel General
    Replies: 1
    Last Post: 05-08-2012, 11:42 PM
  3. Pulling data for a pivot table
    By burnsbe in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 10:58 AM
  4. Pivot Table pulling deleted data
    By jbeal in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 11:01 AM
  5. Help pulling data from pivot table for calculation
    By mike703 in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 05: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