Results 1 to 5 of 5

Pivot Filter Based on Column Group Header ?

Threaded View

  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.

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