I was wondering if anybody can help me with this:
Is it possible to hide cells that has zero value or that are blank (in PIVOT)? Like to show only cells that has value more then 0 and are not blank?
Thank you!
Marija
I was wondering if anybody can help me with this:
Is it possible to hide cells that has zero value or that are blank (in PIVOT)? Like to show only cells that has value more then 0 and are not blank?
Thank you!
Marija
In the pivot, click on the field. i.e. Sum of Sales. You should be able to uncheck the zero and (blank). Is this what you are looking for?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks