Pivot table

[SSR]

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

 

[Workforce_info_Kings_NHS]

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.