+ Reply to Thread
Results 1 to 2 of 2

Changing Pivot Table Headers when Filters Change

  1. #1
    Registered User
    Join Date
    09-14-2018
    Location
    Pennsylvania
    MS-Off Ver
    Office 2013
    Posts
    6

    Changing Pivot Table Headers when Filters Change

    I am building a model where when regions will be selected via a filter in a slicer but need it to change which field is brought in depending on which region is selected. In other words, I want the slicer to stay so that you can easily select the region, but I need the column headers in the pivot to change when the region does. So when "Region B" is selected in the filter, "Region B Grouping" shows up in the columns instead of "Region A Grouping" since it would be a pain (and easy for other people looking at the model to make a mistake) to have to change what goes in the column each time. Is this possible?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Changing Pivot Table Headers when Filters Change

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    https://www.excelforum.com/excel-cha...s-changed.html
    Ben Van Johnson

+ 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. Changing Pivot Table Data Source - Connected Filters Error
    By adrenom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-09-2016, 02:27 PM
  2. Changing The Dates On Pivot Table Filters Using VBA
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-01-2015, 12:21 AM
  3. Changing the Pivot Table Filters based on Multiple Cells
    By dbnhc8 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-28-2012, 02:37 PM
  4. Replies: 1
    Last Post: 02-22-2012, 12:21 PM
  5. Changing the name of cell headers in the pivot table
    By SEMMatt in forum Excel General
    Replies: 2
    Last Post: 09-01-2011, 03:03 PM
  6. Change pivot table filters on VBA userform combox box change?
    By Teemu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2011, 05:49 AM
  7. Change Pivot table text for totals & col headers?
    By Sue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-15-2006, 12:20 PM

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