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

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