Pivot table help (blank) fields

[shripaldalal]

Hi,

I have a huge problem...... I have a pivot table with report 3 from
autoformat applied to it.

The only problem is that there are (blank) fields at many places along
with their subtotal (as per my list), many times there are figures in
the amount field but text fields may be blank

Can i avoid a (blank) field from being displayed......along with it's
subtotal.........but the fields subgrouped in the (blank) field should
still display along with their corresponding amounts ?

I can send the excel file to you.

Regards,
Shripal.

 

[Dave Peterson]

You could just type over that cell with (blank) in it.

If you have trouble, maybe using Debra Dalgleish's pivottable addin would
help--besides, there's lots of other stuff in that addin that you may like:

http://www.contextures.com/xlPivotAddIn02.html

 

[shripaldalal]

dave,

i can remove the blank by typing a space in it........ i just dont want
the subtotal next to the field when if it's blank

can i have an if then subtotal.......that if the field is blank then it
shudnt have a subtotal ?????? and if it's not blank there shud be a
subtotal ?????

shripal d.

 

[Dave Peterson]

Try right clicking on the (blank) subtotal.
choose Field Settings
choose None for the Subtotals

If you don't want the (blank) to show up, you can use the arrow key in that
field header to show what you want.

If you really want (blank) to show up, but the quantity to be gone, I think I'd
go back to the original data and insert another column and pivot on that:

=if(a2="","",a2)

and force those values to be "" or 0's.