G
Guest
Hi,
I've seen many questions on this subject, but none of the solutions seem to
work for me. I have a pivot table that summarizes billing amounts for 20-25
different data items. Also, the rows have two fields. For Example:
Name I.D. Data
Total
John Smith 7756 U.S. Tax Return $800
John Smith 7756 State Tax Return $250
John Smith 7756 Add'l State Return $0
John Doe 8876 U.S. Tax Return $800
John Doe 8876 State Tax Return $0
John Doe 8876 Add'l State Return $0
I'd like to hide the rows with a zero value. I tried coding the summary
worksheet (from which the pivot table pulls) to return "" rather than 0 if
the service was not performed. I then unchecked "show blank items," and
unchecked the "show blank as...." and "show zero as...." items.
I also tried Debra D's macro, but when I run it, it seems to run
continuously and doens't hide anything. (I have to escape from it to stop
it.)
All I need to do is hide the rows with zero values. Is this possible?
I've seen many questions on this subject, but none of the solutions seem to
work for me. I have a pivot table that summarizes billing amounts for 20-25
different data items. Also, the rows have two fields. For Example:
Name I.D. Data
Total
John Smith 7756 U.S. Tax Return $800
John Smith 7756 State Tax Return $250
John Smith 7756 Add'l State Return $0
John Doe 8876 U.S. Tax Return $800
John Doe 8876 State Tax Return $0
John Doe 8876 Add'l State Return $0
I'd like to hide the rows with a zero value. I tried coding the summary
worksheet (from which the pivot table pulls) to return "" rather than 0 if
the service was not performed. I then unchecked "show blank items," and
unchecked the "show blank as...." and "show zero as...." items.
I also tried Debra D's macro, but when I run it, it seems to run
continuously and doens't hide anything. (I have to escape from it to stop
it.)
All I need to do is hide the rows with zero values. Is this possible?