Pivot table
I want to display in my pivot table report data fields which have no value
yet but I dont want those fields to up as "blank", instead they need to be displayed empty as in the database. How do I accomplish that ? I have tried formating them via table options checkbos for empty cells, show...but the report keeps showing the word "blank" for that field. Please help. ssr |
Pivot table
This might not help you but a possible workaround would be to use a
calculated value (in a separate column) and actually use the calculated column in the pivot table instead of the data entry column. e.g. if your actual data items are in column C then create a column with a formula something like '=if(isblank(C2),"",C2)' Then use the new column in the pivot table where you were previusly using column C. "SSR" wrote: I want to display in my pivot table report data fields which have no value yet but I dont want those fields to up as "blank", instead they need to be displayed empty as in the database. How do I accomplish that ? I have tried formating them via table options checkbos for empty cells, show...but the report keeps showing the word "blank" for that field. Please help. ssr |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com