+ Reply to Thread
Results 1 to 3 of 3

Changing Columns/Series in Pivot Tables when Filter is changed

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

    Changing Columns/Series in Pivot Tables when Filter is changed

    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. For example, when "Region A" is selected via the filter, I want the column/series to change to "Region A Grouping" automatically. Is this possible?

  2. #2
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Changing Columns/Series in Pivot Tables when Filter is changed

    By that, do you mean disappearing/reappearing slicers...based on selection? Don't show "Region A Grouping" all the time; only when "Region A" is selected?

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

    Re: Changing Columns/Series in Pivot Tables when Filter is changed

    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.

+ 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. Change Chart Pivot series Colour depending from Pivot Table Filter value
    By BrianAll in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2018, 02:20 PM
  2. Replies: 1
    Last Post: 02-25-2018, 09:47 PM
  3. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  4. Paths changed by excel in pivot tables
    By vascobmcastro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2015, 05:14 AM
  5. One filter/ Master filter multiple pivot tables based on worksheet...
    By jlworden in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-10-2013, 11:16 AM
  6. Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables
    By tash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 05:32 PM
  7. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM

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