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