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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By rose9812in in forum Excel Programming / VBA / Macros
Last Post: 09-16-2015, 06:03 AM
By rose9812in in forum Excel Formulas & Functions
Last Post: 09-14-2015, 10:51 AM
By Mark89 in forum Excel Programming / VBA / Macros
Last Post: 08-01-2014, 02:21 PM
By Pratik Bhatia in forum Excel Charting & Pivots
Last Post: 10-15-2013, 10:00 AM
By shantanuk in forum Excel Charting & Pivots
Last Post: 12-24-2012, 08:20 AM
By zonino in forum Excel Programming / VBA / Macros
Last Post: 11-21-2009, 04:15 PM
By ebergkes in forum Excel General
Last Post: 11-10-2005, 08:30 PM
- 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