+ Reply to Thread
Results 1 to 5 of 5

Pivot Filter Based on Column Group Header ?

  1. #1
    Registered User
    Join Date
    08-04-2022
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    2

    Pivot Filter Based on Column Group Header ?

    Sorry if the title is confusing, my first post!

    I'm looking to create a pivot table in which I can show the values of A B and C, and have a slicer of sorts to switch between Eng/Frn/Combined with a click.

    Is this possible? If so, what would be the easiest method to accomplish what I'm looking to do? Thank you!

    Please see the example table attached:
    Example.xlsx
    Last edited by Shekal; 08-04-2022 at 02:21 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,683

    Re: Pivot Filter Based on Column Group Header ?

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-04-2022
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    2

    Re: Pivot Filter Based on Column Group Header ?

    Hello friend, thank you for the reply!
    Please see the edited original post to include a link to the example file created. Only dummy data has been input, but it is in the same structure as our reports.

    Thank you for any assistance!

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,683

    Re: Pivot Filter Based on Column Group Header ?

    Cannot open the file. Getting an error message that the file format may not be correct.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,392

    Re: Pivot Filter Based on Column Group Header ?

    Same problem for me. Getting an error message that the file format may not be correct.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Replies: 1
    Last Post: 05-08-2021, 11:09 PM
  2. Replies: 2
    Last Post: 02-24-2020, 06:13 AM
  3. [SOLVED] Filter Pivot table based on max date in column
    By dpelizzari in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2015, 03:30 AM
  4. Replies: 2
    Last Post: 01-29-2015, 07:13 PM
  5. Pivot table: How to use same data for filter and column header
    By eyalasko in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2014, 05:59 AM
  6. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  7. Group value in columns with header based on value in another column
    By hitarov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2013, 03:44 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