+ Reply to Thread
Results 1 to 3 of 3

Filter Pivot table to eliminate showing certain data

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Filter Pivot table to eliminate showing certain data

    Hello:

    Please refer to attached file.
    I have data is Sheet1 and i have created Pivot Table.
    I need to eliminate displaying all data wild char *-x in Column B.

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

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

    Re: Filter Pivot table to eliminate showing certain data

    I feel as if I have to be missing something, however it would seem as if deselecting -x and -xx at the bottom of the filter list for the ID column would accomplish what you want.
    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
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Filter Pivot table to eliminate showing certain data

    Hi riz,

    Is this what you need?
    PivotTable Not Contain Row Filter 4 Riz.xlsb

    Right click in column B in your PT and then on Filter and then on Label Filter. Use the dropdown on the "Label Filter (ID)" dialog and see if this doesn't get you what you need.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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: 4
    Last Post: 07-30-2020, 11:39 PM
  2. Multiple pivot charts showing different data for same pivot table
    By gwood97 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2019, 06:07 PM
  3. Hiding Row after Filter Table has no data points showing
    By Shaywood in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2019, 10:03 AM
  4. [SOLVED] Pivot Table- Data no longer in table source still showing
    By Smally in forum Excel General
    Replies: 7
    Last Post: 09-10-2014, 11:23 AM
  5. Pivot table not showing the selected items when filter added
    By ShaliniGomes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-23-2014, 01:44 AM
  6. Pivot Table not showing the value filter options - only Top 10!
    By abhi.ko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 07:31 PM
  7. Pivot Table not showing all data
    By jmcole in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-27-2013, 08:29 PM

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