+ Reply to Thread
Results 1 to 3 of 3

Need a static column with Slicer in Pivot

  1. #1
    Registered User
    Join Date
    04-12-2023
    Location
    NH
    MS-Off Ver
    365
    Posts
    3

    Need a static column with Slicer in Pivot

    I am wondering if it is possible to create a pivot table and add slicers but keep one of the columns(field values) static while the remaining work dynamically with the slicers. Such as the following.
    In the field settings I have

    Rows
    1 Retailer name:

    Columns
    1 total original quantity ordered
    2 quantity being ship to warehouse

    Slicers
    1 brand of product (3 brand names)
    2 retailer requested receiving date
    3 ETA to warehouse date

    How I'm looking for this to work is that original quantity order will always stay the total sum. Then when you use the slice and pick dates only the ship to warehouse quantity would change. That way I can see that for retailer A that ordered 20 units and I can track the project date to the warehouse what % of that order will be filled on certain dates. For example on the 7/1 10 units are projected to be at the warehouse so I know that 50% of the order will be filled on 7/1.

    I have all the data, and it?s all correct in the pivot table, but it just that the slicer is attached to all columns (field values) in the pivot table. I?m looking to have the slicers disconnect to the total original quantity ordered, yet remain attached to quantity being shipped to warehouse.

    I don?t see any way to independently associate a slicer with specific columns. And I can?t think of any way to get there from another avenue.

    In the original data, I have order numbers, upc numbers, quantity order and dates. On both order data sheet and inbound freight data sheet. I used sumifs and index match to bring the data from the inbound freight into order data (quantity being shipped and ETA to warehouse). Two new columns.

    It?s a one to many relationship. I can have order #1 that has many upc numbers that has serveal delivery request dates and ETA to warehouse on different dates.

    Everything works fine except for the slicers changing the original order quantity
    Last edited by RBowers; 06-29-2023 at 12:27 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Need a static column with Slicer in Pivot

    Sounds complicated, so I am not suggesting that I can resolve the issue, however, someone might have a better chance of offering a solution if we could see a sample of the source data and resulting pivot table.
    Note that you may need to manually mock up a sample of pivot table showing what you want it to display.
    The "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page gives information about attaching a workbook to your next post.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    04-12-2023
    Location
    NH
    MS-Off Ver
    365
    Posts
    3

    Re: Need a static column with Slicer in Pivot

    Appreciate your reply, but I don't think it can be done without some VBA. that's not to say there's someone out there that has figured outa complex work around.

+ 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. [SOLVED] Is it possible to link a table slicer with a pivot slicer?
    By SCarroll in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2023, 12:06 PM
  2. Disconnect Slicer, Change Pivot Source, Reonnect Slicer
    By ensi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2020, 04:26 AM
  3. Replies: 1
    Last Post: 09-11-2019, 11:54 AM
  4. Replies: 1
    Last Post: 04-30-2018, 08:09 AM
  5. One Pivot table to show different column results with slicer
    By milo1984 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-30-2018, 06:26 AM
  6. Filter pivot with slicer for each column
    By tsakta13ole in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-11-2017, 06:07 AM
  7. Keeping Slicer Static
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2016, 09:04 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