| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
zeros generated by a calculated item in pivot table
I added a calculated item in my pivot table. It generated lots of lines with
zeros that did not exist before (indeed the result of my calculation is zero since there is no data); and even, if you double-click on the generated zero, you can see that there is no data behind. Filtering results is not satisfactory to me, because: 1. it does not solve the calculation time issue 2. it hides the row tittel on the left when there is a zero on the same line Can anyone truly solve this issue? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Threaded Mode
