+ Reply to Thread
Results 1 to 2 of 2

Retrieve data from Pivot under Filter

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    182
    MS-Off Ver
    2013
    Posts
    1

    Unhappy Retrieve data from Pivot under Filter

    I need to retrieve sets of data from the same pivot, but under different filters. So far the best solution I've found is to copy that pivot 32 times through VBA for every segment I need. I.e. past 7 days, 7 days before that, 30 days, 30 days before that, and then "Mobile" and "PC" under "Device" filter for all those combinations. You can see how this might be considered inefficient. If I make all filters values instead, I can't reference the values I need directly, or even at all.

    So to sum up, I need to GetPivotData but with specific filter settings. Is this possible?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Retrieve data from Pivot under Filter

    It sounds like something you might want to do with formulas instead of a pivot table. Pivot tables are great but not the answer to everything. Can you upload a spreadsheet with some (just enough to show what you need) data and showing the results you expect? (Go Advanced>Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  2. Replies: 1
    Last Post: 02-27-2014, 09:45 PM
  3. [SOLVED] VBA to filter out data within a pivot
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 10:04 AM
  4. Best way to filter and retrieve data from spreadsheet
    By jmoffett in forum Excel General
    Replies: 1
    Last Post: 07-11-2011, 04:54 PM
  5. Filter data set within pivot table
    By Wa_Wa in forum Excel General
    Replies: 1
    Last Post: 03-23-2009, 03:36 PM
  6. Data filter in Pivot table
    By anandmr65 in forum Excel General
    Replies: 1
    Last Post: 09-27-2006, 09:21 AM
  7. [Pivot] Retrieve Data
    By Sphenix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2006, 10:50 AM

Tags for this Thread

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