Results 1 to 9 of 9

hide blank cell pivot table

Threaded View

  1. #4
    Registered User
    Join Date
    12-26-2009
    Location
    everywhere but nowhere
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: hide blank cell pivot table

    no, from the sample that you gave me it would be changing my pivot table report, what i'm trying to do is, i want that "blank" cells that come out from my pivot table automatically change into 0 or empty not "blank" and without changing the source of the data that have empty cells.

    i try to go to pivot tabe option and check the "for empty cells show : 0" but it doesn't work, as shown in the picture.
    Attached Images Attached Images
    Last edited by verisme; 02-20-2010 at 10:34 PM.

Thread Information

Users Browsing this Thread

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

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