Pivot table

  • Thread starter Thread starter SSR
  • Start date Start date
S

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table (blank) 2
Pivot Table 2
display all row fields in pivot table 1
pivot table data 2
Pivot Table show Zero problem 2
Repeat labels in Pivot Tables 2
Totaling blank cells in Pivot Tables 8
how do I remove #DIV/0! in a pivot table calculation field ? 2

Back
Top