+ Reply to Thread
Results 1 to 2 of 2

multiple label filter in pivot table

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Oakland, California
    MS-Off Ver
    Excel 2007
    Posts
    32

    multiple label filter in pivot table

    I'm trying to do multiple label filters in a pivot table for WEEKNUMBER, which is a column field. I need to exclude (BLANK) and actual blanks. I know how to apply one but not two. I can't do a manual filter for both because I need new week number values to be included every time I refresh data. Is there a way to exclude actual blanks in the source data?
    Attached Files Attached Files

  2. #2
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: multiple label filter in pivot table

    pma85,

    An excel example file of your source would be useful?

    Daveh
    - Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
    - Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post

+ 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. I want to filter every Pivot table on the same row label
    By pkiron33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2013, 06:10 PM
  2. How to apply multiple label filters on pivot table at once
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2013, 02:16 PM
  3. Filter Pivot Table Row Label by Another Row Label
    By bdcelli in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2013, 12:57 PM
  4. Sort multiple row label in pivot table
    By madc0w in forum Excel General
    Replies: 3
    Last Post: 10-31-2010, 01:48 AM
  5. filter a pivot table row label from vba,
    By cesna123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2010, 05:07 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