+ Reply to Thread
Results 1 to 1 of 1

Can I use Power Query to pull from Pivots in multiple workbooks?

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Can I use Power Query to pull from Pivots in multiple workbooks?

    Okay, here's the situation:
    Our Reports group compiles information from various databases into multiple workbooks for my/our use. The source data isn't contained in the workbook, only a pivot of the source is resident in the workbook. For my purposes, I need to access 6 of these files on a regular basis, out of about 20 files in the folder. For each of "my" files, I need to filter the pivot down to only my Expense data, not my Budget or Projection. I also need to change other options in my pivot. For instance, in my FY14 file, the Budget Reference default is ALL, because only FY14 data is in this file. But all of the data I take from my pivot is going to be added to the information from FY15, 16,17, etc, so I need the Budget Reference to reflect the actual budget year.

    OR,
    I need PQ to view the detail information behind the pivot, and remove the items I don't need from that.

    I'm still learning PQ, so this may be easy but I don't know how to do what I need. Please advise.

    I've attached a picture of what my pivot currently looks like in PQ. Not that this is the pivot from only one of my files. I have 6 to do, out of 20 in the folder.

    Thanks.
    Attached Images Attached Images
    Last edited by jomili; 05-31-2016 at 10:33 AM.

+ 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. Macro to Pull Data from Multiple Workbooks to One Master Workbooks
    By eranajoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2019, 09:24 AM
  2. Using Power Query to do multiple searches on a website
    By eodsolo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2014, 09:33 PM
  3. Query to pull from Multiple similar tables
    By Lewis2010 in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-17-2011, 02:40 PM
  4. Pull data from multiple workbooks into one
    By ro55co in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2008, 10:52 AM
  5. Replies: 0
    Last Post: 05-06-2005, 05:06 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