Results 1 to 2 of 2

Filter Function Filtering a Pivot Table: How to reference it as an object

Threaded View

  1. 12-05-2022, 10:13 AM #1
    wherdzik
    wherdzik is offline
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    548

    Filter Function Filtering a Pivot Table: How to reference it as an object

    I have a filter formula that filters a pivot table. Is there a way to reference the pivot table as an object so that when the pivot table resizes the formula does as well. Thank you!


    =FILTER(Pivot!A3:L30,(Pivot!A3:A30="Providers")+(Pivot!A3:A30="Grand Total"))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Cell reference to pivot filter, issue locating correct reference to pivot table field
    By ddali2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2020, 05:18 AM
  2. Cell Reference Filtering a Pivot Table
    By Byebye14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2020, 01:06 PM
  3. Pivot table label filter not filtering out all data
    By amanda.higgins in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2020, 05:35 PM
  4. VBA to filter pivot table from a cell reference in another sheet
    By rickettsd96 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-22-2017, 05:45 AM
  5. VBA to filter pivot table from a cell reference in another sheet
    By rickettsd96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2016, 05:06 AM
  6. Use Cell Reference for Pivot table Filter
    By Miskondukt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2016, 11:22 AM
  7. Excel 2010 - Filtering a filter in a Pivot table
    By proctorar in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-16-2014, 03:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1