+ Reply to Thread
Results 1 to 2 of 2

Pivot - Slicer Change in percentage

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    houston
    MS-Off Ver
    2010
    Posts
    12

    Pivot - Slicer Change in percentage

    Hello I have a pivot table which shows below data which is based on percentage
    TX - 20%
    MD - 20%
    NY - 30%
    CA - 10%
    RI - 20%
    Total - 100%

    Then I added a slicer to my pivot table. On the slicer when I select a specific state then the data becomes like below

    TX - 100%
    Total 100%

    How can i keep the data static - where is shows - TX - 20% by selecting on slicer. Please help. Thanks

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Pivot - Slicer Change in percentage

    You can't. However there are work-arounds. What are you trying to do with the filtered data? Are you trying to chart it? If so, a named dynamic range overlaying the pivot table may help. Are you just trying to display it? If so, a formula may do the trick. It would help a lot also if you can include a sample workbook.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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] Run macro to change pivot table row field when user selected a slicer item
    By Chrispelletier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2016, 09:44 AM
  2. [SOLVED] Percentage change in Pivot
    By Jess0121 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-22-2016, 12:22 PM
  3. [SOLVED] Pivot chart won't change when I add months using the slicer
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-02-2015, 04:59 PM
  4. How to change font size of a pivot Slicer, using VBA
    By Jaffary in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2015, 11:41 AM
  5. VBA to change pivot slicer based on cell value
    By Samantha McNeill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2015, 06:20 PM
  6. Change Pivot Table Column field on Slicer selection (Excel 2013)
    By kevboyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2014, 11:36 PM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 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