+ Reply to Thread
Results 1 to 1 of 1

filter out blanks from pivottable

  1. 05-20-2016, 06:55 PM #1
    stephme55
    stephme55 is offline
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    filter out blanks from pivottable

    Hello. I have a pivot tables with a sum field. Some of these fields are blank because the row values don't have any inputs for that field. How can I filter out blanks?
    Last edited by zbor; 05-23-2016 at 07:30 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting - Color unprotected cells, remove color once text entered
    By jrc905 in forum Excel General
    Replies: 3
    Last Post: 05-30-2014, 10:24 AM
  2. Calculating cells based on the condition of color, but color is chosen via DROPDOWN choice
    By teanza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 03:56 PM
  3. How to filter cell by color in office 2003 (both background color and text color)
    By ryan4646 in forum Excel General
    Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  4. Conditional format to change text color when the cell is manually given a fill color
    By AJHughes in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  5. Find out if a range of cells match a criteria cell, if yes, color Green, if no color Red
    By r71lima in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  6. Automatically change fill color on certain cells depending on color of specific cell
    By cbouley in forum Excel General
    Replies: 3
    Last Post: 07-08-2010, 06:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1