Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
It's there a way to get rid of the (blank)s in a pivot table?? usually, what I do it's unselect the checkbox in the menu however, if i do this now, since the label it's one of many Row Labels if I uncheck it, the whole row goes into oblivion manually, directly on the pivot table can't be done an error appears "cannot chance part of this pivot table" one way i found it's filling with zeroes the data table but it has to be done manually, due the fact that the data it's going to be updating once a week it's there an PT option on something that allows to NOT SHOW the (blank)s without affecting the table?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove blank from pivot table | Excel Worksheet Functions | |||
Remove "(blank)" in a pivot table? | Excel Discussion (Misc queries) | |||
How do I remove the (blank) from an excel pivot table? | Excel Discussion (Misc queries) | |||
how to remove "(All)" in a pivot table using VBA | Excel Discussion (Misc queries) | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |