+ Reply to Thread
Results 1 to 2 of 2

Extract data from a pivot table using GETPIVOTDATA function

  1. #1
    Registered User
    Join Date
    04-27-2009
    Location
    Montclair, CA
    MS-Off Ver
    Excel 2003
    Posts
    33

    Question Extract data from a pivot table using GETPIVOTDATA function

    I have a pivot table set up but i would like to get data from that pivot data.
    For Example below

    Total Amount (USD) Column Labels
    Categories 01/2016 02/2016 03/2016 04/2016

    Agriculture 9 99 1,061 550
    Grand Total 9 99 1,061 550

    I'm trying to put it into another table like below:

    Date 01/2016 02/2016 03/2016 04/2016
    Total Spend ($) #REF! #REF! #REF! #REF!

    My formula is =GETPIVOTDATA("Total Amount (USD)",$A$10,"PO Period","001/2016") but it's not working.
    Last edited by Philangr8; 10-30-2015 at 04:01 PM.

  2. #2
    Registered User
    Join Date
    04-27-2009
    Location
    Montclair, CA
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Extract data from a pivot table using GETPIVOTDATA function

    I tried it again and it worked. I'm not sure what happened but thanks.

+ 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. Extract data from Pivot Table (If statement & GetPivotdata)
    By rose9812in in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2015, 06:03 AM
  2. Extract data from Pivot Table (If statement & GetPivotdata)
    By rose9812in in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2015, 10:51 AM
  3. Changing OLAP Pivot Table with GetPivotData function
    By Mark89 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 08-01-2014, 02:21 PM
  4. Adding a series of cells in a Pivot Table using GetPivotData function
    By Pratik Bhatia in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-15-2013, 10:00 AM
  5. Extracting data from pivot table using getPivotData function
    By shantanuk in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-24-2012, 08:20 AM
  6. Pivot Table double click extract/ GETPIVOTDATA()
    By zonino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2009, 04:15 PM
  7. [SOLVED] create pivot table formula without the GETPIVOTDATA function
    By ebergkes in forum Excel General
    Replies: 3
    Last Post: 11-10-2005, 08:30 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