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.
Bookmarks