+ Reply to Thread
Results 1 to 3 of 3

Need help with Pivot Table and Slicers to Group Columns

Hybrid View

  1. #1
    Registered User
    Join Date
    04-10-2024
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    2

    Question Need help with Pivot Table and Slicers to Group Columns

    I am trying to make a bar graph with slicers and from what I understand, I first need to make a pivot table based on my data...

    The issue I am running into is that I cant create a header for some of my columns..

    In one column, I have cells that contain the names of my sales people, with the header "Sales Person".
    To the right of it, I have a column that contains the name of the store that the sales person works at, with the header "Store".
    The Next 12 columns to the right of that have the month abbreviated "JAN" "FEB" MAR" etc, and the cells below each month header contain how many units the sales people sold for that month.

    What I want is a slicer named "Month" where I can select "JAN" for example, and see how many units every one sold in January, and then if I wanted to also filter by store, I could use the Store Slicer and select the Store & Month together...

    I thought I could merge 12 cells above the abbreviated months and call the merged cell "months" and that would work, but it gives be and error when creating a pivot table.

    I'll attach a screen shot so you can see what I'm looking at. There might be another way to get my desired result, and I'm happy to hear any ideas.

    EXCEL PIVOT TABLE SLICER.PNG

    Thank you!

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,996

    Re: Need help with Pivot Table and Slicers to Group Columns

    You can use power query to unpivot the month columns so you'll just end up with two columns - month name and value - rather than 12, for each row.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    02-29-2024
    Location
    EGYPT - Cairo
    MS-Off Ver
    MS365
    Posts
    99

    Re: Need help with Pivot Table and Slicers to Group Columns

    Welcome to forum tertiaoptio.
    It seems that you posted twice my friend:
    https://www.excelforum.com/excel-gen...ml#post5939133
    Thank,
    Mohamed GadAllah

+ 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. How to group columns in Pivot table to have a group for Slicer
    By daithy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2023, 02:49 PM
  2. Pivot Table - Group Columns by Custom Dates
    By cola286 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-28-2020, 01:17 AM
  3. Replies: 2
    Last Post: 12-04-2018, 07:57 PM
  4. Group Data on Columns in Pivot Table
    By pbergmann in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-21-2018, 01:27 PM
  5. Group in a Pivot table but keep several text data columns as columns..
    By NunesJunior in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-22-2017, 04:45 PM
  6. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 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