+ Reply to Thread
Results 1 to 2 of 2

Filter specific customer in pivot table.

  1. #1
    Forum Contributor
    Join Date
    01-24-2013
    Location
    NY,NY
    MS-Off Ver
    MS 365
    Posts
    250

    Filter specific customer in pivot table.

    I have a pivot table and I like to use the filter to look up a group of addresses that will tell me how many jobs are open and closed under that specific address. The problem I have is let's say I have a list of customers and their address reads 15 Smith Street the other customers their address is 115 Smith Street. When I type in 15 Smith Street both 15 and 115 Smith Street are displayed. Is there a way to fix this so that when I type 15 Smith only those customers show or when I type 115 only these customer show. But as of right now when I type in 15 Smith Street both 115 and 15 is being displayed. I'm sorry I don't know how else to explain this, this was the best way to explain.

    Thank you for the help and apologies for the description.
    Last edited by thursday140; 06-30-2017 at 06:46 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filter specific customer in pivot table.

    Attach a sample workbook (not a picture). 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.

+ 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 do I get a pivot table to load a specific filter?
    By Slfwui in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-28-2015, 02:30 AM
  2. Getting value of specific customer in a 2 column pivot table
    By Andres007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2014, 08:41 AM
  3. [SOLVED] VBA code to filter on Specific two dates ( pivot table)
    By tejal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-24-2014, 03:36 PM
  4. Pivot table with customer sales data, into an individual report with specific rows
    By fireforge112 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2014, 04:36 PM
  5. How to show full totals in Pivot chart and table when you filter on one customer?
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:30 PM
  6. [SOLVED] Pivot table subtotals by Customer code
    By kisboros in forum Excel General
    Replies: 7
    Last Post: 04-27-2012, 10:58 AM
  7. Pivot table filter by specific day of the month
    By vesapo in forum Excel General
    Replies: 2
    Last Post: 11-29-2010, 02:44 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